Functions for Filtering Related Data Sets

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
ecx:filter	Searches a column for specific values and returns matching entries.
ecx:filterDateRange	Filters entries based on date values within a specified range.
ecx:filterDateTimeRange	Filters entries based on both date and time within a specified range.
ecm:addInterval	Adds or subtracts a specified time interval to/from a date.
ecx:merge	Merges multiple data sources into a single object.
ecm:countMapElements	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, use ecm:countMapElements to 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.