Could not use CheckboxGroup value to query

Queries and Resources
1

I set CheckboxGroup to put where clauses in query. But it causes query error. Someone tell me how it works, please ?

select * from "users" where "type" IN {{checkboxgroup1.value}};

Error: syntax error at or near "$1"

Result of $1:
[
1
]

2

If you’re using Postgres, you should write it like this

select * from “users” where “type” = ANY({{checkboxgroup1.value}});

See here for other databases.

2 Likes
3

Hi, thank you very much.
It solved my problem. Forgive my poor question since it it showed on first of Cheatsheet…

1 Like