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 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:is-defined | 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 the specified expressions all return true. |
| op:sql-condition | 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. |