GET data from supabase with join tables, and NOT IN and IN condition, or with filter to other collection

[luissh84]

Anyone help me to know how to get data using conditions with inner join clause in Supabase, I’m developing an app for leasing management, I want to assign assets to an employee, if the assets is assigned to another employee I don’t want to get this assets in the collection, here are the tables

And here is the WeWeb collection, if I use the filter option, I have only the option to set an specific element of the collection assignments

[Broberto]

Hey, check this out

Supabase - Is it possible to use JOIN statements from within the WeWeb Plugin?

Hello, I’m wondering whether I could make this query with the Supabase Plugin alone, or I need to do this with a PostgreSQL function and do a REST API request as I’m doing now, It would be great to have it in the Plugin, as we could use auth for RLS [Screenshot 2023-06-20 at 11.17.24]

[luissh84]

Thanks @Broberto, do you know if can we use that format direct in Weweb advanced mode ?

[Broberto]

You definitely can, in fact i did it and it worked It might give you some errors, but when you open up the error log, you’ll see reccomendations from Supabase on how to fix it very often.