Show TOC

Background documentationDefine Filter Dialog Box Locate this document in the navigation structure

 

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:

  • Is equal to: Value of the field exactly matches the value defined in the Expression field

  • Starts with: Value of the field starts with the value defined in the Expression field

  • Ends with: Value of the field ends with the value defined in the Expression field

  • Contains: Value of the field contains the value defined in the Expression field

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.