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

Hey, check this out :slight_smile: [image] Supabase - Is it possible to use JOIN statements from within the WeWeb Plugin? How do I? 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…

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

You definitely can, in fact i did it and it worked :slight_smile: 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.

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

Ask us anything

Broberto (Rob) August 10, 2023, 11:06am 2

Hey, check this out

Topic		Replies	Views
How would you filter a JOIN query in Supabase Plugin? How do I? supabase	24	1393	April 29, 2026
I want to create the following query as my custom in weweb advanced Ask us anything supabase	12	559	July 21, 2024
Supabase - Is it possible to use JOIN statements from within the WeWeb Plugin? How do I?	5	692	July 31, 2023
Filter with inner join in supabase How do I? supabase	3	284	October 6, 2024
How to handle Supabase collection fetches w/ foreign key filters? How do I? supabase	17	955	July 22, 2024

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

Related topics