Logic operators

and(boolean0, boolean1, ...) Returns true if all the arguments are true. Otherwise, returns false. Each argument must be boolean.

or(boolean0, boolean1, ...) Returns true if any of the arguments is true. Otherwise, returns false. Each argument must be boolean.

eq(argument0, argument1, ...) Returns true if all the arguments are equal. Otherwise, returns false. The arguments can be string, numeric or boolean.

gt(number0, number1) Returns true if number0 is greater than number1. Both arguments must be numeric.

gte(number0, number1) Returns true if number0 is greater than or equal to number1. Both arguments must be numeric.

lt(number0, number1) Returns true if number0 is less than number1. Both arguments must be numeric.

lte(number0, number1) Returns true if number0 is less than or equal to number1. Both arguments must be numeric.

ifNull(value, replacement) Returns replacement if value is null. Otherwise, returns value.

in(element, array) Returns true if array (must be an array) contains element. Otherwise, returns false.

ne(argument0, argument1) Returns true if both arguments are not equal. Otherwise, returns false.

not(boolean) Inverts the effect of the argument. The argument must be boolean.

Last updated