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:
- Select the type of information and the areas to search.
Click the Criteria tab in the search specification
pane.
- 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.)
- In the Operator box, select the
operator that you want to use with the selected field.
- 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.
- Click Insert to move the criterion
to the edit box.
- 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.
- 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.
- 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.
- Optional: Modify the columns to be displayed
in the results pane of the Results Options tab.
- Click Find Now.