Loading TOC...

op functions (Boolean Expression Functions)

The following functions are used to build boolean expressions.

13 functions
Function name Description
op.and This function returns true if the specified boolean expressions all return true.
op.case This function returns the specified valueExpression if the specified valueExpression is true.
op.eq This function takes two or more expressions and returns true if all of the expressions return the same value.
op.ge This function returns true if the value of the left expression is greater than or equal to the value of the right expression.
op.gt This function returns true if the value of the left expression is greater than the value of the right expression.
op.isDefined This function tests whether the value of an expression is null in the row where the expression might be as simple as a column identified by op.col .
op.le This function returns true if the value of the left expression is less than or equal to the value of the right expression.
op.lt This function returns true if the value of the left expression is less than the value of the right expression.
op.ne This function returns true if the value of the left expression is not equal to the value of the right expression.
op.not This function returns true if neither of the specified boolean expressions return true.
op.or This function returns true if either of the specified boolean expressions return true.
op.sqlCondition This function returns a filter definition as input for a WHERE operation.
op.when This function executes the specified expression if the specified condition is true for the row.