Functions for Filtering Related Data Sets
- 1 Minute to read
- Print
- DarkLight
Functions for Filtering Related Data Sets
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback!
Overview
Using Mapp Engage functions, you can filter related data sets to meet your specific needs. These functions allow for refined selection based on time periods, specific values, or other criteria. Filters can be applied to:
Message content insertion
Audience selection
Personalization rules
Available Filtering Functions
To work effectively with related data sets, the following functions are available:
Function | Description |
|---|---|
Searches a column for specific values and returns matching entries. | |
Filters entries based on date values within a specified range. | |
Filters entries based on both date and time within a specified range. | |
Adds or subtracts a specified time interval to/from a date. | |
Merges multiple data sources into a single object. | |
Counts the number of elements inside a data map. |
Note: When using personalization rules or recipient selections, functions must return a Boolean (True/False). If a function (e.g.,
ecx:filter) does not return a Boolean value, useecm:countMapElementsto derive a Boolean output.
Linked vs. Unlinked Related Data Sets
To filter data, you must define the key of the data set being filtered.
Linked Data Sets
The key is specified via a related attribute.
Filters apply directly based on relationships.
Unlinked Data Sets
The key must be explicitly defined (either as an attribute or a predefined value).
Filtering requires manual key identification.
Important: Filters cannot be used to search all data sets for a certain value without defining the key first. The correct syntax differs between linked and unlinked data sets.
Was this article helpful?