Query filters are Corticon Rule Language expressions that are performed in the database. As such, the operators used in these expressions must be compatible with the database’s native query language, which is based on some form of SQL. Not all Corticon Rule Language operators have comparable functions in SQL. Those operators supported by standard SQL and therefore also permitted in query filters are shown in the following table:

Table 1. Operators supported by query filters
Operator Name Operator Syntax Data types Supported
Add + Decimal, Integer
Subtract - Decimal, Integer
Multiply * Decimal, Integer
Divide / Decimal, Integer
Equal To (comparison) = DateTime, Decimal, Integer, String
Not Equal To <> DateTime, Decimal, Integer, String
Less Than < DateTime, Decimal, Integer, String
Greater Than > DateTime, Decimal, Integer, String
Less Than or Equal To <= DateTime, Decimal, Integer, String
Greater Than or Equal To >= DateTime, Decimal, Integer, String
Absolute Value .absval Decimal, Integer
Character Count .size String
Convert to Upper Case .toUpper String
Convert to Lower Case .toLower String
Substring .substring String
Equal To (comparison) .equals String
Collection is Empty ->isEmpty Collection
Collection is not Empty ->notEmpty Collection
Size of Collection ->size Collection
Sum ->sum Collection
Average ->avg Collection
Minimum ->min Collection
Maximum ->max Collection
Exists ->exists -
Note: The Collection operators listed must be used directly on the extended-to-database alias in order to qualify as a query filter. If the collection operator is used on an associated child alias of the extended-to-database alias, then the expression is processed in memory.