Filter On Table Dialog

You can use the Filter on Table dialog to filter the data output from a selected table. The left-hand side of the dialog contains rule condition and rule action fields and controls that you can use to create a filter. The right-hand side of the dialog enables you to create a filter with plain text or expression code. You need to take one approach or the other: either fill in the left-hand side of the dialog or enter your filter in the right-hand side of the dialog.

The Rule condition section of the dialog contains the following elements:

Field name - Specifies the field used in the filter condition.

Operation - Specifies the operation performed by the filter condition.

Value - Specifies the value used in the filter condition. You can specify single values, multiple values, or a field. You can also enable or disable case insensitivity and wildcards.

Add Conditions - Adds the current condition to the Rule expression field, where you can review the condition that you are creating. You can also add AND and OR and parentheses to conditions. Finally, you can undo and clear conditions.

The Rule action section of the dialog enables you to specify whether a row is removed from the output when the row passes the rule validation or fails the rule validation.

The Rule expression section of the dialog serves two purposes. First, you can use it to display the rule conditions that you create on the left-hand side of the dialog. Second, you can enter rule conditions directly into the Rule expression field. To enable this direct entry function, select the Edit rule expression check box. Note you can also select either Show plain text or Show expression code to determine the format of the rule condition code.

The Rule expression section of the dialog also contains the following elements:

Functions - Enables you to select an expression code function to use in a rule condition.

Fields - Enables you to select a field to use in a rule condition.

Save - Saves a filter to a file.

Load - Loads an existing filter.