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)
Result
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.
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.
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)
Result
UNION ALL
Use to combine all result sets of two or more collections.
(expression)
Result