18. Appendix D: Query Language Operators

18.1 Logical operators

Following boolean operators can be used in expressions:

‘and’

Infix logical and operator.

‘or’

Infix logical or operator.

‘not’

Prefix unary negation operator.

18.2 Arithmetic operators

The following operators can be used, with the usual arithmetic meaning:

‘=’

‘!=’

‘<>’

‘<’

‘<=’

‘>’

‘>=’

18.3 Special operators

‘is not null’

Unary postfix operator, "attribute is not null" evaluates to true exactly if the attribute is not null.

‘not null’

Unary postfix operator, "attribute is not null" evaluates to true exactly if the attribute is not null.

‘is null’

Unary postfix operator, "attribute is not null" evaluates to true exactly if the attribute is null.

‘like’

Behaves exactly like the like operator in SQL. It searches the given attribute, which should be of type String to match the given parameter. The percentage (%) sign is a wildcard matching a string of any characters. This operator is case-sensitive.

‘ilike’

Like the like operator, but this is case-insensitive.

‘contains’

This is a special operator, which is usable with List and Map attributes. "attribute contains object" evaluates to true, if the specified attribute is a List or Map and contains as a value the specified object (false otherwise). Note: Operator can not be negated, either directly nor indirectly, because it would not mean what you think it would mean. If the operator is negated, an exception will be thrown.

This document was generated by Robert Brautigam on November, 21 2009 using texi2html 1.78.