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.

AVG_OF_ANY

MAX_OF_ANY

Last modified 1yr ago