List of ER functions in the list category
Electronic reporting (ER) list functions can be used to extract information from, and perform operations on, data sources of the Record list and Container (record) data types. This article provides a summary of these functions.
List of supported functions
| Function | Description |
|---|---|
| AllItems | This function runs as an in-memory selection. It returns a new flattened Record list value that consists of a list of records that represents all items that match the specified path. |
| AllItemsQuery | This function runs as a joined SQL query. It returns a new flattened Record list value that consists of a list of records that represents all items that match the specified path. |
| Count | This function returns an Integer value that represents the number of records in the specified list, if the list isn't empty. If the list is empty, this function returns 0 (zero). |
| EmptyList | This function returns an empty Record list value by using the specified list as a source for the list structure. |
| Enumerate | This function returns a new Record list value that consists of enumerated records of the specified list. |
| Filter | This function returns the specified list as a Record list value after the query has been changed so that it filters for the specified condition. |
| First | This function returns the first record of the specified list as a Container (record) value, if that list isn't empty. If the list is empty, this function throws an exception. |
| FirstOrNull | This function returns the first record of the specified list as a Container (record) value, if that record isn't empty. If the record is empty, this function returns a null Container (record) value. |
| Index | This function returns a Container (record) value that is selected by using the specified numeric index in the specified list. If the index is out of range for the records in the specified list, this function throws an exception. |
| IsEmpty | This function returns a Boolean value of TRUE if the specified list contains no records. Otherwise, it returns a Boolean value of FALSE. |
| List | This function returns a Record list value that consists of a new list that is created from the specified arguments. |
| ListDistinct | This function calculates the specified expression as a selector for every record of the specified list. It returns a new Record list value that contains a single record for each unique selector value. |
| ListJoin | This function returns a Record list value that represents a new joined list that is created from the specified arguments. |
| ListOfFields | This function returns a Record list value that is created based on the structure of the specified argument of the Enumeration or Container (record) type. |
| ListOfFirstItem | This function returns a Record list value that consists of only the first record of the specified list. |
| OrderBy | This function returns the specified list as a Record list value after it has been sorted according to the specified arguments. These arguments can be defined as expressions. |
| Repeat | This function builds a record that contains the field that has a value that matches the specified input. It then returns a new Record list of a record that is repeated a specified number of times. |
| Reverse | This function returns the specified list as a Record list value in reversed sort order. |
| Split | This function splits the specified input string into substrings and returns the result as a new Record list value. |
| SplitList | This function splits the specified list into sublists (or batches), each of which contains the specified number of records. It then returns the result as a new Record list value that consists of the batches. |
| SplitListByLimit | This function splits the specified list into a new list of sublists (batches). The number of records in each batch is dynamically calculated. The function then returns the result as a new Record list value that consists of the batches. |
| StringJoin | This function returns a String value that consists of concatenated values of the specified field from the specified list. The values can be separated by the specified delimiter. |
| Where | This function returns the specified list as a Record list value after it has been filtered according to the specified condition. |