Workflow Operators
An operator is a character that represents an action. Operators can be used with all data types.
Addition
+: Addition.
Subtraction
-: Subtraction.
Division
/: Division.
Multiplication
*: Multiplication.
Boolean AND
&&: Combines two boolean values. The result is True if both of the combined values are True, False if either of them is False but not NULL, and NULL if either of them is NULL.
Boolean AND - Keyword
AND: Combines two boolean values. The result is True if both of the combined values are True, False if either of them is False but not NULL, and NULL if either of them is NULL.
Boolean NOT
!: Accepts one input. If that input is True, it returns False. If that input is False, it returns True. If that input is NULL, it returns NULL.
Boolean NOT - Keyword
NOT: Accepts one input. If that input is True, it returns False. If that input is False, it returns True. If that input is NULL, it returns NULL.
Boolean OR
||: Combines two boolean values. The result is True if either (or both) of the two values is true. Returns NULL if any of the values is NULL.
Boolean OR - Keyword
OR: Combines two boolean values. The result is True if either (or both) of the two values is true. Returns NULL if any of the values is NULL.
Equal To
=: Equal to.
Greater Than
>: Greater than.
Greater Than or Equal
>=: Greater than or equal.
Less Than
<: Less than.
Less Than or Equal
<=: Less than or equal.
Value IN (...)
IN: Test value in list.
Value NOT IN (...)
NOT IN: Test value not in list.