search in array column #861
Unanswered
moinologics
asked this question in
API Server
Replies: 2 comments
-
Apparently the https://docs.prestd.com/api-reference/parameters#functions-support @moinologics can you implement it? Would be here: prest/adapters/postgres/postgres.go Lines 1531 to 1550 in 9f4f283 |
Beta Was this translation helpful? Give feedback.
0 replies
-
SELECT name FROM users WHERE {{id}} = ANY(blocked_user_ids) @moinologics to solve your problem without implementing the feature in the prestd core you can make custom queries, see the documentation here |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
add support to search in an array column
example -
table
users
resultant query
SELECT name FROM users WHERE {{id}} = ANY(blocked_user_ids)
when id = 1, return
jane
when id = 3, return
john & jane
Beta Was this translation helpful? Give feedback.
All reactions