Specifying Dynamic Filters
You can specify additional search criteria including several conditions, using the Dynamic Filters.
To display the Dynamic
Filters dialog box, click the
icon in the top left corner of the screen to show a hidden section
containing a number of options including Dynamic Filter on Data
View or Summary View page.
To set a dynamic filter
-
In the Dynamic Filters dialog box, select a Boolean operator (AND or OR) to link the search phrases.
By default AND is selected. Click it to change to OR.
Note: If you want to apply only one filter criterion, you don't need to select a Boolean operator.
-
Click
to add a condition. A row of boxes will appear.
-
Select an field from the drop-down list, displaying all data fields from the model.
-
Select a relational operator from the following options: Is equal to, Is not equal to, Is less than, Is less than or equal to, Is greater than or equal to, Is greater than.
-
Enter a value in the box.
-
To add another condition of the same level, click
in the parent level and repeat steps 3-5.
-
To add a nested condition, click
in the current level and repeat steps 1, 3-5.
-
To apply the dynamic filter, click Apply.
Note: To remove
a condition, click .
The following example shows how dynamic filters work:
This filter reads as follows:
Report Date is equal to March 3, 2012 AND (Order Number is not equal to 536020 OR Contact contains Marvin).