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.

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
  • Set to ","
• Order
  • Connected to Id; this is where we want to base our sort on

See Figure 1.

Figure 1