How can you use arrayObj in the SQL IN statement?

Could not get the arrayObj working in the SQL IN statement.
Have an array from a multiselect obj, "selectArray"
when I tried to use it in the SQL, it does not work properly.
WHERE table.field IN ({{selectArray.value}})

any way to make it work?

Try using table.field = ANY(selectArray.value)

1 Like

works, really appreciated