| Category | Function | Description |
|---|
| Logic | AND | Returns TRUE if all of its arguments are TRUE |
| OR | Returns TRUE if any argument is TRUE |
| TRUE | Returns the boolean value TRUE |
| FALSE | Returns the boolean value FALSE |
| NOT | Reverses the boolean value of its argument |
| UNKNOWN | Returns the logical value unknown |
| Text | CONCATENATE | Joins several text items into one text item |
| JOIN | Joins several text items into one text item, while placing a separator character between them |
| MATCH | Checks if a string completely matches a regular expression |
| FIND | Returns found characters if a pattern is found within text value |
| FIRST | Returns the first position where one text value is found within another |
| LAST | Returns the last position where one text value is found within another |
| Statistics | AVERAGE | Returns the average of its arguments |
| MIN | Returns the minimum of a specified value in a list or collection |
| MAX | Returns the maximum of a specified value in a list or collection |
| COUNT | Counts the number of instances in a specified collection |
| Date and Time | DATETIME | Converts a date in the form of text or a date object to a dateTime object |
| DATE | Converts a date in the form of text or a dateTime object to a date object |
| ADD PERIOD TO DATE | Adds a specified period (day, month etc.) to a date |
| ADD PERIOD TO DATETIME | Adds a specified period (day, month etc.) to a date |
| SUBTRACT PERIOD FROM DATE | Subtracts a specified period (day, month etc.) from a date and time |
| SUBTRACT PERIOD FROM DATETIME | Subtracts a specified period (day, month etc.) from a date and time |
| PERIOD BETWEEN | Returns the period (days, months etc.) between two dates, two dateTimes or a date-dateTime combination |
| YEAR | Returns the number of the year |
| MONTH | Returns the number of the month |
| DAY | Returns the number of the day in the month |
| HOUR | Returns the number of hours in a dateTime object |
| MINUTE | Returns the number of minutes in a dateTime object |
| SECOND | Returns the number of seconds in a dateTime object |
| TODAY | Returns today’s date |
| NOW | Returns the current date and time |
| Collection | SIZE collection | Returns the size of a collection |
| UNIQUE collection | Filters duplicate instances in a collection |
| SUBSET OF | Returns a subset of a collection |
| UNION | Combines two collections into one new collection |
| INTERSECTION | Returns the intersection of two collections |
| Math | ADD | Adds two numbers |
| SUM | Sums the specified values in a collection |
| SUBTRACT | Subtracts two numbers |
| DIVIDE | Divides two numbers |
| DIV | Returns the integer portion of a division |
| MOD | Returns the remainder from division |
| ROUND | Rounds a number to a specified number of digits |
| ROUND TO MULTIPLE | Rounds a number to the nearest integer or to the nearest multiple of significance |
| MULTIPLY | Multiplies two numbers |
| PRODUCT | Multiplies the specified values in a collection |
| POWER | Returns the result of a number raised to a power |
| LESS | Compares two number values and returns TRUE when one is smaller than the other |
| LESS OR EQUAL | Compares two number values and returns TRUE when one is equal or smaller than the other |
| GREATER | Compares two number values and returns TRUE when one is greater than the other |
| GREATER OR EQUAL | Compares two number values and returns TRUE when one is equal to or greater than the other |
| EQUAL | Compares two values and returns TRUE when they are equal |
| NOT EQUAL | Compares two number values and returns TRUE when they are not equal |
| List | EXISTS | Returns TRUE if there is an instance that matches the specifications |
| ALL | Returns a collection of all instances of a specified entity |
| COLLECT FROM | Returns a collection for a specified entity |
| COLLECT FROM WHERE | Returns a collection for a specified entity that matches the specified conditions |
| COLLECT FROM NAMED | Returns a collection for a specified entity |
| COLLECT FROM NAMED WHERE | Returns a collection for a specified entity that matches the specified conditions |
| UNPACK | Returns the content of a single-valued list |
| Conversion | TEXT | Converts a value type to string |
| INTEGER | Converts a value type to integer |
| NUMBER | Converts a value type to number |
| CURRENCY | Converts a value type to currency |
| PERCENTAGE | Converts a value type to percentage |
| DATE | Converts a value type to date |
| DATETIME | Converts a value type to datetime |
| BOOLEAN | Converts a value type to boolean |
| More functions | ISUNKNOWN | Replaces an unknown value with a specified value |
| IS A | |
| TYPE OF | |
| AUTHORIZATIONROLES | |
| CHANNEL | |
| LANGUAGE | |
| PAGE | |
| PRIVILEGES | |
EVENT |