How would you filter a JOIN query in Supabase Plugin?

[Ben1]

Ok so I analyzed the request URL sent by the plugin to supabase and I think I understand why the error is raised.

Here is the request URL :
https://xxxxxxxxxxxxx.supabase.co/rest/v1/link_events_domaines_invitations?select=*,...events!inner(\*)&or=(and(domaine_id.in.(17,7,6,2),is_actif.eq.true))

The issue comes from “is_actif.eq.true” it should be “events.is_actif.eq.true”. Maybe something can be done on plugin side ? May I open a ticket for Weweb support team ? @Alexis @Joyce

[Broberto]

I’d maybe try to type in events. before, just for the fun of it and see what happens. You can see how the Supabase plugin is wrote in case you wanna tinker around.

GitHub - weweb-assets/plugin-supabase

[Ben1]

Thanks for the github good idea but it will take me more time to understand the plugin than create a view in supabase

Thanks again for your support @Broberto

[what.gift]

Thanks so much for this guide! This should be in the official ones

!inner syntax was unknown to me, but critical to allow filtering on joined tables.

1. brand!inner(id,name,is_small_business) - allows filtering on brand table
2. brand(id,name,is_small_business) - won’t filter, just provides null values

For others to reference as it can be tricky (yet so powerful) when using the advanced fields/filtering with supabase collections:

Which allows this filter to work which wouldn’t without a inner join.