Operands

This topic lists the supported filter query operands.

Operand Type Syntax Description
Attribute name 
name
 The name of an attribute - see Using Attributes in Query Filters for more information.
String literal 
‘string’
‘str?ng’
‘str*ng’
‘str\?ng’
‘str\\ng’
 A string literal to be used for comparison.

See Using String Literals for more information.

Integer literal 
12345
 A numeric literal.
Boolean literal TRUE or FALSE A boolean literal.
DateTime literal 
YYYY-MM-DDThh:mm:ss.SSS

or for a range: 

{|[YYYY-MM-DDThh:mm:ss.SSS, YYYY-MM-DDThh:mm:ss.SSS}!]
 A date-time literal consisting of the relevant components.

For ranges, a curly bracket indicates an exclusive value; a square bracket indicates an inclusive value.

See Using DateTime Literals for more information.

A query 
(query)
 A sub query to be evaluated before the main query.
Late-bound parameter literal 
::name
 A value which will be late bound to the expression.

See Using Late-Bound Parameter Literals for more information.