How to query data using a join table?
The official doc doesn't provide any examples in querying using a join table: https://supabase.com/docs/reference/javascript/select#query-foreign-tables
So I have two tables
How do I get all products that belong to a certain user in javascript?
I found the same issue here: https://github.com/supabase/supabase/discussions/1080
It says it was a limitation in 2021 and we can only do client-side filtering, what about now?
So I have two tables
product and user which have many-to-many mapping relationship, and I have a third join table product_user which has three fields: id, product_id and user_id. How do I get all products that belong to a certain user in javascript?
I found the same issue here: https://github.com/supabase/supabase/discussions/1080
It says it was a limitation in 2021 and we can only do client-side filtering, what about now?
GitHub
Hey folks! I have a question related to this discussion here and figured I'd break it out into it's own post. Basically, I'm using @kiwicopple 's suggestion to creat...
Performs vertical filtering with SELECT.