© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
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 banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

checking if value in column (defined as array) contains given substring
SupabaseSSupabase / help-and-questions
4y ago
Filter for 'contains any' for an array column, searching by an array
SupabaseSSupabase / help-and-questions
4y ago
Filter from JSON with CS (contains)
SupabaseSSupabase / help-and-questions
4y ago
Using contains query for a nested jsonb column
SupabaseSSupabase / help-and-questions
4y ago