You are here: Processor Library > Advanced > Expression Filter

Expression Filter

The Expression Filter processor allows you to write an expression using OEDQ'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.

Use

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.

Configuration

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 OEDQ's expression language. See notes below.	None

Click for detailed notes on OEDQ'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

Results Browsing

Statistic	Meaning
True	The number of records that passed the expression filter test
False	The number of records that failed the expression filter test

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

Example

In this example, a simple expression is used to find records that represent males. The rule expresses a test where the record must either have a Title of 'Mr' or 'Monsieur', or a Gender of 'M' or 'male':

((@'Title' = "Mr" | @'Title' = "Monsieur") | (@'Gender' = "M"|@'Gender' = "male"))

The summary results view of the processor shows the results of the filter:

Drilldown on True: