What value should I pass to Supabase SELECT "Match at least one filter" condition?

[WilliamB (William)]

Hello Weweb Community!

I’m having a hard time understanding what to put in the value field of the “Match at least one filter“ condition of the Supabase SELECT action workflow.

I have a bunch of filters in the same SELECT action and I’d like to have an “OR“ instead of an “AND“ clause so that the rows that are filtered contain one of the values from the filters, but not necessarily all of them.

Thanks a lot in advance

EDIT : after messing around a bit, it seems that it works by strictly following the Supabase doc and passing a value with this structure ‘column1.eq.xValue,column2.eq.xValue‘.

Can someone confirm this is the way?

[Agustin_Carozo (Agustin M. Carozo)]

Hi William

We do have docs about the general use of the Supabase Select action but indeed we don’t go deep about your specific question.

Database | Select | Documentation

Did manage to solve it by using Supabase’s structure?

[rivan_sigarlaki]

Hi William, that seems right. Match at least one filter is same as OR condition.

Here’s reference from Supabase docs about it. The “condition” is set in the Value: ‘id.eq.2,name.eq.Han’ or ‘[key1].eq.[key1Value],[key2].eq.[key2Value]‘

[WilliamB (William)]

Hi Rivan. Indeed, that’s what I did, and it works perfectly. Thanks