IBM FileNet P8, Version 5.2.1            

Setting the search criteria

Use the Criteria tab to enter a filter condition to view specific items and to determine the order in which the results are displayed.

For example, you can filter all items with Expense Report in the Subject field to see only those items that are related to expense reports. If you do not enter any filter condition, you can see all items.

Tips:
  • Fields that begin with "F_" are system-defined fields.
  • You can manually edit or create filter conditions in the edit box. For example, you might want to add more complicated expressions, to place or rearrange parentheses, or to modify AND and OR operators.
  • Click Clear to clear out the edit box and start over.
  • Use New Search to reset the Criteria and Results Options tabs. The top portion of the search specification pane remains the same.
  • To search for null fields, use the IS NULL operator.
  • To search for an empty string:
    • For Microsoft SQL Server, enter =".
    • Oracle database treats an empty string as a null field.

To set the search criteria:

  1. Select the type of information and the areas to search. Click the Criteria tab in the search specification pane.
  2. From the Search Fields list, select the search field that you want to use in the filter. (Search fields consist of the system and data fields that are exposed for the workflow roster, queue, or event log.)
  3. In the Operator box, select the operator that you want to use with the selected field.
  4. In the Value box, enter the value or expression you want to compare to the search field.
    • When you search by using string comparisons, you can use the LIKE operator combined with a wildcard character to find inexact matches.
    • For time fields, use a valid format. Process Administrator converts the time that you enter to a format that is understandable by the workflow system when the value is inserted into the edit box.
    • For Boolean fields, Process Administrator converts the value you enter when the value is inserted into the edit box as follows: true = 1, false = 0.
    • For string fields, Process Administrator automatically encloses the string in quotation marks when the value is inserted into the edit box. If the string contains a quotation mark, Process Administrator adds another quotation mark to it. For example, the string Tom's workflow is displayed in the edit box as 'Tom''s workflow'. Searches that are made against a SQL Server database are not case sensitive; searches that are made against an Oracle or DB2® database are case sensitive.
  5. Click Insert to move the criterion to the edit box.
  6. To add more criteria, click the AND or OR, and then repeat the steps to add a criterion. Use parentheses to modify the precedence of the operators in an expression. Clicking the AND, OR, (, or ) places the corresponding text or symbol at the end of the filter conditions in the edit box.
  7. You can determine the order in which your results are displayed by selecting from the available predefined indexes in the Use index list. If you do not select an index, Process Administrator uses the default system index. If you select an index and the index has searchable fields, you can click Advanced to further restrict the search results by entering minimum and maximum values for the indexed fields.
  8. To limit your search to one or more specific users when you search in user queues, click the Users tab, and select the user names that you want to search for. By default, the search returns all users.
  9. Optional: Modify the columns to be displayed in the results pane of the Results Options tab.
  10. Click Find Now.


Last updated: October 2015
bpfah006.htm

© Copyright IBM Corporation 2015.