Comment on page

Logical-or |, or

Operator: | , or
The logical operator | (or) checks if at least one of two conditions evaluates to true. The operators | and or can both be used and are exactly the same.
If used together with the logical and operator, the precedence is important: and takes precedence over or. We strongly advice to use (parentheses) to correctly group these logical statements.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a Yes/No value, depending on the check
  • If Condition1 and Condition2 both evaluate to false, then No is returned.
  • if Condition1 or Condition2 evaluates to true, then Yes is returned.
condition1 | condition2
(6=6) | ("Hello world" = "Hello world") => Yes
false | false => No
false | true => Yes
true | "text" => expression type mismatch
condition1 or condition2
(6=6) or ("Hello world" = "Hello you") => Yes
false and true or false => No
false and true or true => Yes
(false and true) or true => Yes
false and (true or true) => No