Filter action

In the Filter action screen, you create an expression for selecting records based on their column data (when defining a Filter by columns) or based on their attributes (when defining a Filter by record attributes). Only records that fall within the Filter scope will be affected.

Filter action for columns

Use the Expression Builder to define a record selection expression based on column data. Click the fx button to open the Expression Builder.

The Expression Builder opens displaying the Data tab. Define an expression using the available parameters.

Example (Assumes that "Age" is the column being filtered):

Create the following expression to select all records for citizens between the age of 50 and 80.

$AR_M_SOURCE_COLUMN_DATA > '60' AND $AR_M_SOURCE_COLUMN_DATA < '70'

Filter action for record attributes

Use the Expression Builder to define a record selection expression based on record attributes. Click the fx button to open the Expression Builder.

The Expression Builder opens displaying the Headers tab. Define an expression using the available Header columns.

Example:

Create the following expression to select UPDATED records only:

$AR_H_OPERATION='UPDATE'

 

See also: Using the Expression Builder