Match Criteria Operators

The following operators are used to define Match Criteria expressions:

Table 11-21: Understanding Operators

Logic OperatorClosedThe instructions used to evaluate a number, date or text string: greater than (>), equal to (=), or contains, to name a few. Operators are use to build ad hoc searches, report parameters and alert conditions.

Description

=

The selected field is equal to the value.

>

The selected numeric or date field is greater than the value.

>=

The selected numeric or date field is greater than or equal to the value.

<

The selected numeric or date field is less than the value.

<=

The selected numeric or date field is less than or equal to the value.

!=

The selected field is not equal to the value.

AND

Used to evaluate more than one field. All fields must match in order for the value to be imported. The following example shows how this is configured:

  • SOURCE[RSK!TBL_INC_CASES!LOCATION] = 'Ann Arbor' AND SOURCE[RSK!TBL_INC_CASES!SITE] = ‘ER’

OR

Used to evaluate more than one field. At least one field must match in order for the value to be imported. The following example shows how this is configured:

  • SOURCE[RSK!TBL_INC_CASES!LOCATION] = 'Ann Arbor' OR SOURCE[RSK!TBL_INC_CASES!LOCATION] = 'Lansing'