Operators
An operator is a character that represents an action. Use an arithmetic operator to perform mathematical calculations or a Boolean operator to work with true/false values. Operators can be used with all data types.
Block Comment
/*Comment*/
: Use a block comment operator to add a comment block to an expression editor (within the expression line) without interfering with the expression.
Single Line Comment
// Comment
: Use the single line comment operator to add a single-line comment to an expression editor without interfering with the expression.
Addition
Addition +
: Use the addition operator to add multiple numeric values together.
Boolean Operators
Boolean AND &&
: (Boolean AND) Use this operator to combines 2 Boolean values. The result is also a Boolean value. The result is True if both of the combined values are true, and the result is False if either of the combined values is false.
Boolean AND - Keyword
: (Boolean AND) Use this operator to combines 2 Boolean values. The result is also a Boolean value. The result is True if both of the combined values are true, and the result is False if either of the combined values is false.
Boolean NOT !
: (Boolean NOT) Accepts one input. If that input is true, it returns False. If that input is false, it returns True.
Boolean NOT - Keyword
: (Boolean NOT) Accepts one input. If that input is true, it returns False. If that input is false, it returns True.
Boolean OR - Keyword
: (Boolean OR) If either (or both) of the two values are true, it returns True.
Boolean OR ||
: (Boolean OR) If either (or both) of the two values are true, it returns True.
Close Parenthesis
Close Parenthesis )
: Close Parenthesis
Division
Division /
: Use the division operator to divide a numeric value by another numeric value.
Equal To
Equal To =
: Equal To
Greater Than Operators
Greater Than >
: Greater Than
Greater Than Or Equal >=
: Greater Than Or Equal To
Less Than Operators
Less Than <
: Less Than
Less Than Or Equal <=
: Less Than Or Equal
Multiplication
Multiplication *
: Use the multiplication operator to multiply multiple numeric values together.
Not Equal To
Not Equal To !=
: Not Equal To
Open Parenthesis
Open Parenthesis (
: Open Parenthesis
Subtraction
Subtraction -
: Use the subtraction operator to subtract a numeric value from another.
Value IN Operators
value IN (...) - Keyword
: (Test Value in List) Determines if a given value matches any value in a subquery or a list.
value NOT IN (...) - Keyword
: (Test Value Not in List) Determines if a given value matches any value not in a subquery or a list.