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

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
Was this page helpful?