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)