Conditional Statements

The conditional statements are functions that select an expression to return depending on a conditional expression.

FunctionSignatureDescription
if()if (bool exp, exp1, exp2)Test for a condition, returning one of two values
case()case(. . ., bool exprN, resultN, else)Test for a condition, returning one of two or more values
decode()decode(field, caseValue, thenValue, elseValue)Test for a condition, returning one of two or more values
caseContains()caseContains(string field, string caseValue, string thenValue, ..., string elseValue)Test for a condition, returning one of two or more string values
caseContains()caseContains(string field, boolean caseSensitive, string caseValue, string thenValue, ..., string elseValue)Test for a condition, returning one of two or more case sensitive string values