- Contents
Exchange Manager Help
Set Custom Filter Criteria
Use the Enter Filter Criteria for... dialog box to customize selection criteria for any column in the query results. You can combine criteria to create more complex filters.
To set custom filter criteria
-
With a query tool window open, in the toolbar, click Run. The results appear on the Results tab.
-
In the column heading of the column to filter, click the Funnel icon. A list of options for the specified column appears.
-
Click (Custom). The Enter Filter Criteria for... dialog box appears. The following example shows the dialog box for the Desk column.
-
In the Operand list box, click an operator. For more information, see Custom Filter Operators.
-
In the Operand list box, click or type an operand. The condition appears at the bottom of the dialog box.
-
To add conditions, click Add a condition. The system adds a blank row.
-
To delete a condition, click the condition and then click Delete Condition.
-
If you set multiple conditions, do one of the following:
-
To set the filter so that all the conditions have to be true for an account to appear in the query results, click And conditions. For example, desk does not equal "000000" and desk does not equal "000002" means that you want to see accounts for all desks except "000000" and "000002".
-
To set the filter so that only one condition has to be true for an account to appear in the query results, click Or conditions. For example, desk equals "000000" or desk equals "000000" means that you only want to see accounts for desks "000000" or "000002".
-
When finished creating the custom filter, click OK.