Use this screen to create or delete (relational) filters.
Note
This is an optional step.
The main controls of this screen are described in the following table:
Control |
Description |
---|---|
And/Or |
Specifies and/or conditions for multiple filters. The And/Or control is enabled after the first filter has been added. Select from the following values for second and subsequent filters:
|
Field |
Lists all fields from all the tables selected on the Select Fields screen. Select the field for which to configure the filter. |
Operator |
Lists operators that specify how the Field entry and the corresponding Value entry should be compared. Available operators are:
|
Value |
Enter the value to which to compare the field. The value can be either numeric or text. |
And (Is between operator only) |
If you have selected Is between as your operator, enter the end value for your range. |
Add |
Transfers the filter to the Filters list. |
Filters list |
Lists the currently configured filters. |
Delete |
Deletes a selected filter from the Filters list. |