Page History
...
| 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 |
Conversion
Convert a value of one data type into a value of another data type using conversion functions. The following conversion functions are available:
- from string to integer, number, currency, percentage, date, dateTime or boolean
- from integer to string, number, currency or percentage
- from number to string, integer, currency or percentage
- from currency to string, integer or number
- from percentage to string, integer or number
- from date to string or dateTime
- from dateTime to string or date
- from boolean to string, integer or number
Syntax
TEXT(integer, [format], [locale])
TEXT(number, [format], [locale])
TEXT(currency, [format], [locale])
TEXT(percentage, [format], [locale])
TEXT(date, [format])
TEXT(dateTime, [format])
TEXT(boolean, [format])INTEGER(string, [format], [locale])
INTEGER(number)
INTEGER(currency)
INTEGER(percentage)
INTEGER(boolean)NUMBER(string, [format], [locale])
NUMBER(integer)
NUMBER(currency)
NUMBER(percentage)
NUMBER(boolean)CURRENCY(string, [format], [locale]
CURRENCY(integer)
CURRENCY(number)PERCENTAGE(string, [format], [locale]
PERCENTAGE(integer)
PERCENTAGE(number)DATE(string, [format])
DATE(dateTime)DATETIME(string, [format])
DATETIME(date)BOOLEAN(string, [format])- value - The value of the date type that is converted.
Examples
- TEXT(PERCENTAGE(1.2), “00.00”, “nl-NL”) results in a string value “01,20”
- INTEGER(“1,0”, ”#0.0”, “nl-NL”) results in an integer value 1
- NUMBER(TRUE) results in a number value 1.0000
- CURRENCY(“1.2”, “invalidPattern”) results in a currency value 1.20 (an unknown pattern will be ignored)
- DATETIME(“19861221 12:02:56”, “yyyyMMdd HH:mm:ss”) results in a dateTime value 1986-12-21T12:02:56
- BOOLEAN(“1”,”1;0”) results in a boolean value TRUE
Formats in the runtime
Each data type is defined in the runtime as follows:
- INTEGER #0
- NUMBER #0.0000
- CURRENCY #0.00
- PERCENTAGE #0.00
- BOOLEAN true,1;false,0
E.g.: numbers will always be shown with 4 decimals.
More functions
ISUNKNOWN
This function replaces a value if that value is unkown.
Syntax
ISUNKNOWN(attribute, value)
- attribute - Attribute of which the value has to be returned if that value is known.
- value - Value to return if the attribute value is unknown.
Return type
- any type, equals the attribute type
Examples
Suppose the following data model.
| Person.name | Person.SequenceNumber |
|---|---|
| “Bob” | 654 |
| “Jane” | ? |
| “Mary” | 667 |
| “Rick” | ? |
| “Ron” | ? |
| “Jenny” | 765 |
- for Jane, ISUNKNOWN(Person.SequenceNumber, 999) returns 999
- for Mary, ISUNKNOWN(Person.SequenceNumber, 999) returns 667
...
Overview
Content Tools