संपादित करें

इसके माध्यम से साझा किया गया


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.

Additional resources

Electronic Reporting overview

Formula designer in Electronic reporting

Electronic reporting formula language