LIST_OF_ANY
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.
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.Last modified 1yr ago