With the following code i can check if a certain value is in either of the listed fields.
AND ANY v IN [f.Owners.owner1FName, f.Owners.owner1LName, f.Owners.owner2FName, f.Owners.owner2FLame]
SATISFIES LOWER(v) like LOWER($2) END
How can i check if a value is in a list of arrays like below which does not work
AND ANY v IN [send_to, send_cc, send_bcc]
SATISFIES LOWER(v) like LOWER($2) END
or is the only way do it like this ?
AND (ANY v IN tr.send_to
SATISFIES v = $2 END
or ANY v IN tr.send_cc
SATISFIES v = $2 END
or ANY v IN tr.send_bcc
SATISFIES v = $2 END)