List function

Contents > Functions reference (alphabetical list) > Aggregate functions > List function

List function

Format


List(field{;field...})

Parameter

field - any related field, repeating field, or set of non-repeating fields; or an expression that returns a field, repeating field, or set of non-repeating fields.

Parameters in curly braces { } are optional.

Data type returned

text

Description

Returns a concatenated list of non-blank values (separated by carriage returns) for either:

a single field (table::field), calculates a single result over all repetitions (if any) for this field and over all matching related records, whether or not these records appear in a portal.

several fields and/or literal values (table::field1,constant,table::field2...), calculates a separate result for each repetition of the calculation across each corresponding repetition of the fields. If any fields are related, only the first related record is used.

Examples

In the following examples:

Field1 contains white.

Field2 contains black.

Field3 contains three repetitions with values of red, green, blue.

Related::Field4 refers to three records that contain 100, 200, 300.

Note When referencing multiple repeating fields, List() returns the list of the values across the first repetition in the calculation's first repetition, then the list of the values across the second repetition in the second repetition, and so on.

Example 1

List (Field1; Field2) returns:

white

black

Example 2

List(Field3) returns:

red

green

blue

Example 3

List (Field1; Field2; Field3) returns:

in calculation repetition 1: