© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•8mo ago•
2 replies
bizmate

Rest API not returning correct rows, only coming back empty.

My app is fetching

https://PID.supabase.co/rest/v1/premium_plan?select=*&status=in.%28active%2Ccoming_soon%29&order=plan_cost.asc.nullsfirst

url decoded
select=*&status=in.(active,coming_soon)&order=plan_cost.asc.nullsfirst
select=*&status=in.(active,coming_soon)&order=plan_cost.asc.nullsfirst


and the response is []

but the table does contain premium plans with active or coming_soon statuses. So what do i do to fix it? The status is an enum type plan_status
faultySupabaseRest_2025-06-28_17-34-33.png
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

Empty query back.
SupabaseSSupabase / help-and-questions
4y ago
Supabase SECRET keeps coming back
SupabaseSSupabase / help-and-questions
6mo ago
Database api doesn't seem to be returning correct data
SupabaseSSupabase / help-and-questions
4y ago
Supabase vs Rest Api
SupabaseSSupabase / help-and-questions
9mo ago