LIST_OF_ANY

Description

LIST_OF_ANY is the flexible counterpart of LIST.

It looks at all values you provide in between a set of brackets, each separated by a comma, and returns them as a single list.

After listing the values between the brackets, provide the symbol which should separate the values in the output - for example a space.

Example

JOIN(
LIST_OF_ANY(
p.title,
p.first_name,
p.middle_name,
p.last_name
),
' '
)

This expression builds the full name of a person, including title, joining whichever of the values given are available.

If the case is about President (p.title) John (p.first_name) Fitzgerald (p.middle_name) Kennedy (p.last_name), this expression has as output:

President John Fitzgerald Kennedy

Note the space between the individual values in the output, as defined in the second argument of JOIN. Had you written ’-’ there, the output would have been:

President-John-Fitzgerald-Kennedy

If only a first and last name have been filled out in the system, the return of this LIST_OF_ANY expression is:

John Kennedy

Had the expression used the LIST operator instead, and only ‘John’ and ‘Kennedy’ are known values, the system would have alerted you to provide the missing values ‘title’ and ‘middle_name’, before giving you a result.