I need to add WHERE IN condition to the query like this:
`WHERE order_items.id IN ({{ table2.data.id}});`
where table2.data.id are all ids from the table2.
How can I do that?
Currently, I’m receiving error like this:
invalid input syntax for integer: "{"18535","18534","18536"}"
Hey @ckissi! The syntax here is kind of tricky, and depends on how table2.data.id
is formatted. Based on the error message, it seems like you’ve got extra curly braces in there: you might be able to get around that by using Object.values(table2.data.id)
. Could you send a screenshot of the property inspector (left side panel) so I can see what table2.data.id
is?