The following functions are used to build boolean expressions.
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 returns true if the left and right 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. |