Is There a Way To use the '.in()' method with two columns

Hey guys hope everyone is well, just a quick question, does anyone know if its possible to make this a single query, I'll show a screenshot of the code below but will explain what im trying to do first:
Im trying to fetch all the data from a colum where a column contains any user in a array of users, but im trying to fetch from two different columns.

See Code Below:
https://i.imgur.com/X5ReVtU.png

Imgur

garyaustin•12/8/22, 6:26 PM

You could use the or filter with two ins.

Ggaryaustin You could use the or filter with two ins.

ultrafyOP•12/8/22, 7:01 PM

could you demonstrate for me

Matthew Ieyoub•12/8/22, 7:24 PM

Hi, I believe I can help here. Please see https://supabase.com/docs/reference/javascript/filter. You can build the query using multiple filters. Something like:

.filter("user_email", "in", ...)
.filter("user_id", "in", ...)

.filter("user_email", "in", ...)
.filter("user_id", "in", ...)

Supabase Documentation

undefined | Supabase

The open source Firebase alternative.

garyaustin•12/8/22, 7:57 PM

SpazMonkey shows the way if you want to and the two columns.

If you want data if either column is in your array then you use .or...
https://supabase.com/docs/reference/javascript/or#notes The example shows one in filter and another filter, you would just do two in filters.

Supabase Documentation

or()

ultrafyOP•12/9/22, 10:42 AM

awesome thank you very much !

ultrafyOP•12/9/22, 11:14 AM

ultrafyOP•12/9/22, 11:14 AM

not sure if im doing it incorrectly

ultrafyOP•12/9/22, 11:14 AM

the planData?.plan_authorizedUsersplanData?.plan_authorizedUsers is an array

ultrafyOP•12/9/22, 11:14 AM

that contains either emails or uuid

ultrafyOP•12/9/22, 11:14 AM

or both

garyaustin•12/9/22, 3:49 PM

You could have just used two .in() filters if you are anding the two columns.

ultrafyOP•12/10/22, 9:26 AM

awesome

ultrafyOP•12/10/22, 9:26 AM

Is There a Way To use the '.in()' method with two columns

Similar Threads

Similar Threads

Similar Threads