1.3.1.4 Expression Filter

The Expression Filter processor allows you to write an expression using EDQ's expression language, which will be used to pass or fail records and split them into different output filters.

The Expression Filter processor is effectively an advanced form of the Logic Check processor, which provides a GUI to construct the expression. As the Logic Check GUI shows the expression as it is constructed, it is therefore possible to learn how valid expressions are constructed using Logic Check.

Expression Filter is useful where you want to apply a simple test to all input records, and split out records that pass the test from records that fail it.

Inputs

The Expression Filter processor may take any number of inputs, of any type, with the exception of formal Date attributes.

Options

Option Type Purpose Default Value

Logic expression

Expression

The required filter logic, in EDQ's expression language. See notes below.

None

See Expression Notes for detailed notes on EDQ's expression language.

Outputs

Data Attributes

None

Flags

Flag Purpose Possible Values

ExpressionFilter

Stores the result of the expression filter test

Y - if the test passed

N - if the test failed

Execution

Execution Mode Supported

Batch

Yes

Real-time Monitoring

Yes

Real-time Response

Yes

Output Filters

The following output filters are available from an Expression Filter processor:

  • True - that is, records that passed the expression filter test

  • False - that is, records that failed the expression filter test