Operators and Functions

multiply, divide

i * j / k

Arithmetic operators for numeric types only.

percent

i % j

Calculates i as a percent of j; numeric types only.

add, subtract

i + j - k

Arithmetic operators for numeric types only.

equal

i == j

Comparison operators for string, numeric, and date types.

not equal

i != j

less than

i < j

Comparison operators for numeric and date types only.

less than or equal

i <= j

greater than

i > j

greater than or equal

i >= j

IN set

i IN ('apples','oranges')

Sets can be of any type.

IN range

i IN (j:k)

Ranges must be numeric or date types.

NOT

NOT( i )

Boolean operators. Parentheses are required for 
NOT.

AND

i AND j AND k

OR

i OR j OR k

parentheses

()

Used for grouping.

startsWith

startsWith(i, 'prefix')

Comparison operators for strings.

endsWith

endsWith(j, 'suffix')

contains

contains(k, 'substring')

concat

concat(i, ' and ', j, ...)

Returns the string of all parameters concatenated.

testProfileAttribute¹

testProfileAttribute (table_ID.field_ name,'profileAttribute')

table_ID.field_name is the table name and 
field name of the field you're comparing to a profile attribute. This argument can also be an 
expression, such as a concatenation of fields. It cannot be a constant or a groovy call. 
profileAttribute is the name of the user profile attribute.