Functions

A function name is given in capital letters and is followed by a parenthesis. Arguments are given within the parenthesis, separated by commas.

For example:

OLD (STAI)
ISBLANK (TRIM (CORI))
SUBSTRING (PARM, 1,2)

This table shows the available functions and their descriptions:

Functions Description
IF(comparison, trueExpression, falseExpression) Returns either trueExpression or falseExpression depending on the result of the comparison. Example expression for a virtual field:
IF(INDEXOF(FUDS,'ABC') >= 0, 'ABC', FUDS)
INDEXOF(string, substring) Returns the index of the first occurrence of the substring within the string, or -1 if there is no occurrence.
INDEXOF(string, substring, fromIndex) Returns the index of the first occurrence of the substring within the string, starting at the specified index, or -1 if there is no occurrence.
ISBLANK(field) Returns true if the field is empty; otherwise, the value returned is false.
ISCHANGED(field) Returns true if the field has a different value than its old value; otherwise the value returned is false.

This function can only be used for received events with the Update operation.

OLD(field) Returns the old value of the field.

This function can only be used for received events with the Update operation.

SUBSTRING(string, beginIndex, endIndex) Returns a substring of the string.

The attribute beginIndex is zero-based and inclusive. The attribute endIndex is zero-based and exclusive. For example, to extract 'CD' from the string 'ABCDE', use beginIndex = 2 and endIndex = 4.

TOUPPER(string) Converts all characters in the string to uppercase.
TOLOWER(string) Converts all characters in the string to lowercase.
TRIM(string) Removes leading and trailing white space from the string.