op functions (Boolean Expression Functions)
The following functions are used to build boolean expressions.
14 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.in | This function returns true if a test expression evaluates to the same value as any of a list of candidate expressions. |
| 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. |