Hi everyone, I am fetching a collection of user profiles but want to provide the ability to filter the users by their interest tags which are specified through a multicategory select option. These tags are stored in a separate junction table. When a user filters for specific tag(s), I want to be abl…

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-…

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

Ask us anything How do I?

Broberto July 21, 2024, 4:59pm 18

It’s only in the Workflow Actions. You could work around this by first … spreading the data and then filtering on top level

1 Like

[Supabase] Become a Supabase Magician in WeWeb (With Examples of JOINS etc.)

Topic		Replies	Views
"Advanced" filtering best practices How do I? filter , supabase	12	616	July 21, 2024
Supabase collections and pagination How do I? filter , supabase	6	598	November 8, 2023
Filter with inner join in supabase How do I? supabase	3	150	October 6, 2024
Filter elements for a many2many database How do I?	4	438	September 17, 2023
Different profiles collections How do I?	4	44	November 25, 2024

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

Related topics