Filter with inner join in supabase

Ask us anything How do I?
1

@Broberto

Hello everyone and broberto, not only can he answer me but I’m almost sure he has the answer. I learned from you how to do inner join with supabase in advanced mode, but how do I filter something that came from the inner join and not from the main table? I couldn’t

2

Hello Enzo :slight_smile: 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.

3

So the filter doesn’t work as a collection, right?

In the form of collections, I tried two ways to do what I need: 1- using the supabase plugin 2- trying the rest of supabase

create table
  public.produtos (
    id uuid not null default gen_random_uuid (),
    codigo text null,
    nome text null,
    marca uuid null,
    categoria uuid null,
    fornecedor_padrao uuid null,
    unidade text null,
    ncm text null )

create table
  public.produtos_eans (
    id uuid not null default gen_random_uuid (),
    ean text null,
    data_cadastro timestamp with time zone null,
    data_alteracao timestamp with time zone null,
    alterado_por uuid null,
    produto uuid null
  )

I have these two tables, I needed to select “produtos” by doing an inner join with “produtos_eans” but being able to filter the “produtos_eans.ean” column

Using the supabase plugin, it doesn’t work as you explained. From the rest of the api I don’t know why but it also doesn’t let me filter a column that is from a table coming through join

solutions?

Note: Because it is software for my company where only my employees will use it and will have restricted access, I thought about using the SQL plugin, but the performance is poor, right?

4

Yes, you’re right, you need to switch to the Workflow Actions, because the Collections don’t allow custom keys.