skip to main content
Corticon Studio: Rule Modeling Guide : Writing Rules to access external data : Precondition and Filters as query filters : Operators supported in Query Filters
 

Try Corticon Now
Operators supported in Query Filters
Query Filters are Corticon Rule Language expressions which 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 always 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 table below:
Table 8. Operators supported by Query Filters
Operator Name
Operator Syntax
Datatypes Supported
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 above 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.