NEX operators

This list includes operators currently supported for rule expressions.

Does not equal

Returns Boolean; takes all formats.

Equals

Returns Boolean; takes all formats.

Greater than

Returns Boolean; takes number, date, and datetime formats.

Greater than or equal to

Returns Boolean; takes number, date, and datetime formats.

INTERSECT

Use to combine values in the result set that are common to both collections.

(expression)

Less than

Returns Boolean; takes number, date, and datetime formats.

Less than or equal to

Returns Boolean; takes number, date, and datetime formats.

IN

True if parameter one is in parameter two (chosen from multiple values); Boolean.

NOT

Reverse parameter; Boolean.

Null coalescing (??)

Returns a default value when a specific value is not available.

Can also be used to reduce redundant syntax in expressions. See the ANY or ALL NEX functions.

Subtract

Returns and takes number and date formats.

Sum

Returns and takes number and date formats.

AND

True if all parameters are true; Boolean.

OR

True if any parameters are true; Boolean.

Parentheses

Indicate precedence; all formats.

(expression)

UNION

Use to combine the result set of two or more collections.

Note: UNION selects only distinct values by default. Use UNION ALL to allow duplicate values.

(expression)

UNION ALL

Use to combine all result sets of two or more collections.

(expression)