You use the Define Filter dialog box to filter data by specific field values.
You display the Define Filter dialog box by selecting a Filter operator icon on the Design board and clicking the browse button next to the Configuration field in the Configure Element task panel, or by right-clicking the Filter operator icon on the Design board and choosing Define Operator from the context menu.
The Define Filter dialog box contains the following items:
Item |
Description |
---|---|
Add Row |
Adds another row to the list. You can then define the field according to which you want to filter the data. Data must match all the conditions defined in all the rows of the Define Filter dialog box to be passed through the filter. |
Delete Row |
Removes the highlighted row from the list. |
Field |
The data field by which you want to filter the data. In the dropdown list, you can select a field from the data source connected to the operator, or you can select Define expression to define a field using the Dynamic Expression Editor dialog box. |
Condition |
The condition by which to filter the field values. You can choose from the following conditions:
|
Expression |
The filtering expression by which to filter the data. You can enter an expression, or click the fx button to define an expression using the Dynamic Expression Editor dialog box. |
Description area |
Displays a description of the selected filter definitions, in plain-language sentence format. For example, Filter by =@BANK_CTRY is equal to DE, and by =@CITY starts with Be OR Fr. |