LIST_OF_ANY is the flexible counterpart of
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.
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:
If only a first and last name have been filled out in the system, the return of this
LIST_OF_ANY expression is:
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.