Boolean operators (AND, OR, XOR, NOT)

Boolean operators (AND, OR, XOR, NOT)

Can be used to perform Boolean operations like AND, OR, XOR and NOT.

Syntax

= NOT(expression1)

= expression1 OPERATOR expression2

Arguments

expression1	An expression which is to be operated upon. The expression can be specified as an equality (e.g., USERNAME() = “lskywalker”), an inequality (e.g., Quantity > 10), as a combination of expressions (e.g., USERNAME() = “lskywalker” OR Quantity>10).
expression2	An expression which is to be operated upon. The expression can be specified as an equality (e.g., USERNAME() = “lskywalker”), an inequality (e.g., Quantity > 10), as a combination of expressions (e.g., USERNAME() = “lskywalker” OR Quantity > 10).

Examples

Example	Returns
= Not(UnitPrice > 20)	False if the UnitPrice is greater than 20 else returns True
= (Quantity > 10) OR (UnitPrice>10)	True if either of the Quantity or the UnitPrice are greater than 10.
= (Quantity > 10) XOR False	The XOR value of the expression and the boolean False.