Aggregate - Ordered List
Ordered List Aggregate Functioid
Description:
The Ordered List Aggregate Functoid will create a character seperated list.
Inputs with their allowed values:
- Field
- The field that needs to be put into the list
- Seperator
- The character that is used to seperate the field values
- Order
- The field yielding integer values that is used to determine in what order the values are put into the collection. Values that are not integers will generate an error message.
_OrderedList_aggregate_functoid_01.png)
Picture of the Ordered List Aggregate Functioid
Remark:
The Ordered List Aggregate Functoid is often a good way to prepare record sequence if planning on using the new Ordered Consolidation features.
Example:
- Field
- Connected to the field Name; Aim is to have a list of people sorted in order of their Id
- Seperator
- Order
- Connected to Id; this is where we want to base our sort on
See Figure 1.
_OrderedList_aggregate_functoid_02.png)
Figure 1