© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Search
Star
Feedback
Setup for Free
S
Supabase
•
3y ago
•
2 replies
Vic
REST URL Filter: Column contains value
Hey everyone
, I
'm using the REST API calls and I have a table called org
_user
_lob which has a column called lob
_list which is an array of integers
.
I
'm trying to structure the REST url properly to filter only the rows which the array column lob
_list contains for example the number 5
.
This is how I have it right now but is not working
:
rest/v1/org_user_lob?lob_list=contains.%5B5%5D
rest/v1/org_user_lob?lob_list=contains.%5B5%5D
Supabase
Join
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Recent Announcements
Similar Threads
checking if value in column (defined as array) contains given substring
S
Supabase / help-and-questions
4y ago
Filter for 'contains any' for an array column, searching by an array
S
Supabase / help-and-questions
4y ago
Filter from JSON with CS (contains)
S
Supabase / help-and-questions
4y ago
Using contains query for a nested jsonb column
S
Supabase / help-and-questions
4y ago