Skip navigation FileNet logo
Glossary  |  Help Directory  
  Help for Process Administrator
  Search  |  Index
Process Reference  
Process Administrator
Getting started
Searching
  About workflows and work items
  Count or search for workflows
  Set the search criteria
  Set the results options
  About search results
  View the next set of results
  Show, hide, or rearrange the results columns
  Refresh selection
Print search results
  Export search results
Managing work items
Events & statistics
Troubleshooting
   

Set the search criteria

Use the Criteria tab to enter a filter condition and to determine the order in which the results display.

Entering a filter condition is an easy way to view specific items. For example, you can filter all items with "Expense Report" in the Subject field to see only those items related to expense reports. You can see all of the items in the selected location by not entering any filter conditions.

To set the search criteria

  1. Select the type of information and the areas to search by following the procedures described in steps 1 through 4 in Search for workflows. Click the Criteria tab in the search specification pane.
  2. From the Search Fields list, select the search field 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 you want to use with the selected field.
  4. Enter the value or expression you want to compare to the search field in the Value box.
    • When searching 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 Configuration Console converts the time you enter to a format understandable by the Process Engine when inserting it into the edit box.
    • For boolean fields, Process Administrator converts the value you enter when inserting it into the edit box as follows: true = 1, false = 0.
    • For string fields, Process Administrator automatically encloses the string in single quotes when inserting it into the edit box. If the string contains a single quote, Process Administrator adds another single quote to it. For example, the string Tom's workflow appears in the edit box as 'Tom''s workflow'. Searches made against a SQL Server database are not case-sensitive; searches made against an Oracle database are.
    • When searching for a specific value of the F_WobNum field on a SQL Server database, you must precede the value with "0x" and remove the single quotes surrounding the value in the edit box.
  5. Click Insert to move the criterion to the edit box below.
  6. To add additional criteria, click the AND or OR button, and then repeat steps 2 through 6. Use parentheses to modify the precedence of the operators in an expression. Clicking the AND, OR, (, or ) buttons 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 display by selecting from the available pre-defined indexes in the Use index drop-down. If you do not select an index, Process Administrator uses the system's default index. If you select an index and the index has searchable fields, you can click Advanced button 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 searching in user queues, click the Users tab, and select the desired user names. By default, the search returns all users.
  9. Modify the columns to display in the results pane in the Results Options tab if desired.
  10. Click Find Now.

 

    SEARCH TIPS

Fields beginning with "F_" are system-defined fields. See System fields for field definitions and notes.

To search for null fields, use the IS NULL operator. To search for an empty string, SQL Server requires that you enter =''. (An Oracle database treats an empty string as a null field.)

You can manually edit or create filter conditions in the edit box. For example, you may wish to add more complicated expressions, to place or rearrange parentheses, or to modify AND and OR operators.

Click the Clear button 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.

Related topics

Search for workflows

Set the results options