How to use ."in" filter in Supabase URL

Yash

I am trying to use ".in" filter of Supabase using its URL. However I can't query for more than 1 filter.

Working url

https://DATABASE_URL/rest/v1/patients?payer=in.(TERM1)

Here I get all the rows where payer is TERM1. However, when I try the following

https://DATABASE_URL/rest/v1/patients?payer=in.(TERM1, TERM2)

I only get all the rows where payer is TERM1. Expected output would be to get all the rows where payer is either TERM1 or TERM2

Payer column is of type text.

Any help would be appreciated! Thanks.

Bo Lu

Can you try to remove the space between TERM1 and TERM2 and try it again? Like this:

https://DATABASE_URL/rest/v1/patients?payer=in.(TERM1,TERM2)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

How to use a servlet filter in Java to change an incoming servlet request url?

How to use a filter in a controller?

How to filter the data use equal or greater than condition in the url?

How to use search filter when slug is used in URL path

How to get "COUNT(*)" in Supabase

how to use filter in grails

How to filter json on url?

How to handle redirect from supabase signin?

How to use Redux RTK Query with Supabase

How to handle redirect from supabase password recovery?

Supabase REST: how to refresh token?

Supabase how to query the same table twice

How to query text[] column in Supabase?

How to use Supabase streams to query "IS NOT NULL" where clause

how delete row with PostgreSQL RLS - supabase

How to customize supabase email?

How to queries in supabase realtime?

How to use RTK-Query with Supabase

How to filter output of a URL

Supabase RLS | How to check the boolen cells?

Supabase - Row Level Security Policy (RLS) how to limit access with SUPABASE_ANON_KEY to authenticated user only?

react native supabase facebook login redirect callback site url

How can I password protect every page in NextJS and Supabase, using the Supabase default auth helpers and UI?

Cannot read properties of undefined (reading 'SUPABASE_URL')

How to listen to database changes with condition flutter supabase?

How exactly are Supabase realtime DB listeners billed?

Supabase self host: how to connect with nodejs and prisma

How to fix Hydration with supabase auth

Supabase Postgre / Database Function how to log and debug?