Cannot chain multiple ilike or filter with ilike

[harshdeep-techstax]

Unable to chain multiple ilike like this

supabase.table("products").select("*", count='exact').filter("name","ilike",f"%KitKat%").filter("category","ilike",f"%Candy Bar%").order(sort).limit(limit).execute()

Getting error like

[silentworks]

That's a Cloudflare error, maybe the service was down at the time you tried this. Try again and let me know the result.

[harshdeep-techstax]

Still getting the same error on single ilike as well

[silentworks]

Please check if your project is paused in the Supabase dashboard.

[FBosler]

I am also getting those errors when using any kind of filtering (even on unchained fitlers), like:

• ilike
• like
• filter

One operation that works is eq. Using version 2.4.5

[regtm]

The % in the built query is causing your error, as the % is used for url encoding. Use * instead.

[harshdeep-techstax]

The % in the built query is causing your error, as the % is used for url encoding. Use * instead.

Yeah adding * instead of % worked.

[silentworks]

I finally got around to testing this out and cannot replicate the issue you are both facing. I also looked in the postgrest repo and notice there are tests to make sure these methods were tested correctly. Here is a video I created demonstrating that this is working in my codebase.

Supabase_Filter_Like.mp4

[harshdeep-techstax]

@silentworks can you try chaining multiple ilikes as single ilike is working. I said multiple ilike chaining
for example select().ilike("title","%Home%").ilike("description","%father%").

It is now working when I replace % with *

[silentworks]

@harshdeep-techstax Its the same results for me with either single of multiple chaining ilikes.

supabase_filter_ilike_multiple.mp4