The following functions are used to build boolean expressions.
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. |