These functions provide tools to organize structured information. They are used to work with data saved as a list of values or stored as a collection of key/value pairs.

Because they recognize and preserve the relationship between mapped keys and their corresponding values, these functions retrieve and organize information stored in Related Data sets.

To filter data, it is always necessary to specify the key of the data sets that are filtered. In the case of linked related data sets, the key is specified by the linked attribute. In the case of unlinked related data sets, the key must be explicitly identified (as an attribute or defined value). It is not possible to use a filter to search for all data sets that contain a certain value; you must always indicate which data sets are filtered. This is done by identifying the key. For more information about formats for linked and unlinked related data sets, see ​Function Syntax and Formatting.


Function

Description

​ecx:sort​

Returns entries sorted in ascending or descending order based on the values in a target column.

​ecx:filter​

Searches a column for specific values and returns matching entries.

​ecx:filterDateRange​

Searches a column for date values between the specified start and end dates and returns the entries that match.

​ecx:filterDateTimeRange​

Searches a column for values between a specified start and end date and time and returns the entries that match.

​ecx:filterDuplicates​

Returns only distinct entries from a target source with duplicate rows filtered out.

​ecx:merge​

Merges multiple target sources into a single object.

​ecx:related​

Gets the value for the specified key from the given related data set.