Still no way to use ilike on multiple columns?

Hi everyone,

Is there no way to search (e.g., using like in javascript) on multiple columns?

I am creating a search box that I want to be able to search %searchInput% on multiple columns.

I am currently using the .ilike(...)

I prefer not to create my own function and rather use something inbuilt in the javascript superbase caller.

Best regards Aron

garyaustin•12/7/23, 2:53 PM

You can use a computed field and use .ilike on it. You still have to write a postgres function, but it is used as part of the normal js like a column. https://postgrest.org/en/latest/references/api/computed_fields.html#computed-fields

aron7590OP•12/7/23, 2:59 PM

Yes I saw those docs, but what deterred and correct me if I am wrong, but I need to create that function for each tabel I want to use it on.

So if I want to use it and a table1-4 and view1-4 then I have to create the function 8 times

witch is not scalable imo.

garyaustin•12/7/23, 3:03 PM

With views you could just create the extra column in the view.

There is nothing built into the REST API to do joined columns.

garyaustin•12/7/23, 3:05 PM

The other option is to do an .or() with multiple ilikes.

aron7590OP•12/7/23, 3:05 PM

allright that sounds decent

aron7590OP•12/7/23, 3:05 PM

how can I do that?

garyaustin•12/7/23, 3:05 PM

Use the .or() filter.

garyaustin•12/7/23, 3:06 PM

https://supabase.com/docs/reference/javascript/or

Match at least one filter | Supabase

aron7590OP•12/7/23, 3:06 PM

.or(name.ilike.*name.ilike.*, %${searchInput}%%${searchInput}%)
?

garyaustin•12/7/23, 3:07 PM

You have to do as shown in the example and have all the columns with ilike as the filter. All the ilike/column/value tests you use are separated by a comma.

garyaustin•12/7/23, 3:09 PM

.or('name.ilike.%term%, search_terms.ilike.%term%').or('name.ilike.%term%, search_terms.ilike.%term%')

aron7590OP•12/7/23, 3:29 PM

that worked perfectly, thank you so much

Still no way to use ilike on multiple columns?

Similar Threads

Similar Threads

Similar Threads