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.

If you are working with text values, consider using JOIN_OF_ANY instead.

Example

p is Person
LIST_OF_ANY(
    p.title,
    p.first_name, 
    p.middle_name, 
    p.last_name
)

This expression extracts the name components of a person, including title. 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']

If only a first and last name have been filled out in the case, 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 asked users to provide the missing values ‘title’ and ‘middle_name’, before giving you a result.