Value List Functions

All functions in this category are held in memory, therefore you can only use them in Rules, Filters, and Data Monitors. You cannot use these functions in resources like Queries and Reports, and other resources that rely on persisted data.

Caution: Make sure you are getting values from case-sensitive lists only. Getting values from case-insensitive lists will negatively affect performance.

Value List Functions	Description
DistinctListValue	Takes a list and returns list elements, excluding null and duplicate values. The entries are enclosed in double quotes and separated by commas.
GetListElement	Takes two parameters, a list field and a list index (an integer), and returns the value from the specified nth index. The first list element is index 0. See Using Functions: Examples with Lists for additional information.
GetSizeOfList	Takes as an argument the value of a multi-valued list entry and returns the size of the list. For more about lists, see List Authoring. See Using Functions: Examples with Lists for additional information. Note: This function works for both multi-valued active and session lists with overlapping entries.
ListIntersection	Takes two lists and returns a single list containing values that are common to both lists, including null and duplicate values. Entries are enclosed in double quotes and separated by commas. Null values are represented as empty strings (“”). If List1 and List2 each contain one null value and 1.0.0.1, this interested list is returned: “”,“”,“1.0.0.1”,“1.0.0.1”
ListUnion	Takes two lists and returns a single list containing combined entries of both lists, including duplicates and null values. The entries are enclosed in double quotes and separated by commas. Null values are represented as empty strings (“”).
NonNullListValues	Takes one list and returns a list of elements except null values. The entries are enclosed in double quotes and separated by commas.
SortListValues	Takes one list and returns a list of elements, excluding null values, sorted in ascending order. The entries are enclosed in double quotes and separated by commas.