Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

Excerpt

Returns true if either argument evaluates to true. Equivalent to the || operator.

  • Each argument can be a literal Boolean, a function returning a Boolean, or a reference to a column containing Boolean values.

Since the function returns a Boolean value, it can be used as a function or a conditional.

Info

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Logical Operators.

 

D s
snippetBasic

D code

derive type:single value: OR(daysBillOverdue > 90, violationsCount > 2) as:'cancelAccount'

Output: If the value in the daysBillOverdue column is greater than 90 and the value in violationsCount column is greater than 2, then the value in the new cancelAccount column is true. Otherwise, the value is false

D s
snippetSyntax

D code

derive type:single value:OR(value1, value2)

ArgumentRequired?Data TypeDescription
value1YstringThe first value must be a Boolean literal, column reference, or expression that evaluates to true or false.
value2YstringThe first value must be a Boolean literal, column reference, or expression that evaluates to true or false.

D s lang notes

value1, value2

Expressions, column references or literals to compare as Boolean values.

  • Missing or mismatched values generate missing results.

D s
snippetusage

Required?Data TypeExample Value
YesFunction or column reference returning a Boolean value or Boolean literalmyHeight > 2.00


D s
snippetExamples

Example - Logical Functions

Include Page
EXAMPLE - Logical Functions
EXAMPLE - Logical Functions

D s also
labellogical