Logical
IF - THEN - ELSE
Description
Checks a condition specified by comparison field or expression.
If the IF condition returns true, the THEN operations are calculated.
If the IF condition returns false, the ELSE operations are calculated.
ELSE is optional, and will return NULL when not set.
Syntax
IF <Comparision field or Expression>
THEN <Expression or Field or Constant>
[ELSE <Expression or Field or Constant>]
Supported values
All values can be used.
NULL handling
If the result of the IF condition is NULL, the ELSE operations are calculated.
Example
IF User = "Robot" THEN "Automated event" ELSE "Manual event"
AND
Description
Compares two conditions, and returns true if both of comparison field values or expressions are true.
Syntax
<Comparison field or Expression> AND <Comparison field or Expression>
Supported values
All values can be used. Both values must be of the same kind.
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
Department = "Sales" AND Salary > 50000
OR
Description
Compares two conditions, and returns true if any of comparison field values or expressions is true.
Syntax
<Comparison field or Expression> OR <Comparison field or Expression>
Supported values
All values can be used. Both values must be of the same kind.
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
Department = "Sales" OR Salary < 50000
NOT
Description
Returns the inverse of a boolean value.
If the result of the condition is true, the NOT operation will return false. If the condition is false, the NOT operation will return true.
Syntax
NOT <Comparison field or Expression>
Supported values
All values can be used.
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
NOT Department = "Sales"