How to handle Supabase collection fetches w/ foreign key filters?

Ask us anything How do I?
10

If you do fetch the items/products table instead, you can do

*,tags:id(*)

If your item’s id is referenced in tags, you’ll get an array of objects like such:

[
   {
   "name":"product-1",
   "tags": [{"name":"tag-1"},{"name":"tag-2"} ...]
   },
   {
   "name":"product-2",
   "tags": [{"name":"tag-5"},{"name":"tag-3"} ...]
   },
...
]

If you post your schema/table definitions regarding this issue here, I can write this for you.

1 Like