How can you use arrayObj in the SQL IN statement?

Queries and Resources
1

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?

2

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

1 Like
3

works, really appreciated