Filter with inner join in supabase

[Broberto]

Hello Enzo I’m super glad you learnt the JOINs, it’s super handy indeed. Sam had a similar question in my main topic, you might wanna have a look.

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

If you go and use a workflow instead of a Collection, you should be able to set a filter on a news.active column and it could work like this, as that is the “true reference” to that column.