NEX operators

This list includes operators currently supported for rule expressions.

Does not equal

Returns Boolean; takes all formats.

IF(address_type__v != 'M', INVALIDATE())

Equals

Returns Boolean; takes all formats.

IF(hco_status__v == 'I', INVALIDATE())

Greater than

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

IF (feed__v.records > 1000, FAILJOB('Feed contains too many records'))

Greater than or equal to

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

IF(LEN(email_1__v) >= 16, REJECT('Email address is too long'))

INTERSECT

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

(expression)

[ "foo", "star", "ball", "app" ] INTERSECT [ "foo", "bar", "fox", "app" ]

Result

[foo, app ]

Less than

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

IF (feed__v.records < 100, FAILJOB('Feed must contain 100 or more records'))

Less than or equal to

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

IF (feed__v.records <= 99, FAILJOB('Feed must contain 100 or more records'))

IN

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

IF (email_1__v IN ['test4@test.com', 'test5@test.com'], REJECT())

NOT

Reverse parameter; Boolean.

IF(NOT EXISTS(addresses__v), REJECT())

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.

specialty_1__v = specialty_1__v??'None__c'

If specialty_1__v is NULL (or undefined) set the value as NONE.

Subtract

Returns and takes number and date formats.

STRING(HCO.Sales - HCO.Cost, '$###,##0.00)

Sum

Returns and takes number and date formats.

RIGHT(NAME, FIND(NAME, “,”)+1)

AND

True if all parameters are true; Boolean.

IF((!ISNULL(hco_end_date__c) && hco_end_date__c < NOW(), hco_end_date__c, NOW())

OR

True if any parameters are true; Boolean.

IF(primary_country__v = 'US' || primary_country__v = 'CA', REJECT())

Parentheses

Indicate precedence; all formats.

(expression)

IF((email_1_v == 'test4@test.com') || (email_1_v == 'test5@test.com'), REJECT())

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)

[ "foo", "star", "ball", "app" ] UNION [ "foo", "bar", "fox", "app" ]

Result

[foo, star, ball, app, bar, fox]

UNION ALL

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

(expression)

[ "foo", "star", "ball", "app" ] UNION ALL [ "foo", "bar", "fox", "app" ]

Result

[foo, star, ball, app, foo, bar, fox, app]