Hi,
I use supabase to store contacts and I want to make a search in n8n that returns only contact that have a phone number (so phone number is not empty) but when I tried queries like (Phone%20%231.neq.‘’) or similar once they did not work.
Can you try changing your column name to make sure it’s something simple instead of having special characters and spaces? If changing column name is not possibile, try creating a different database with the simple column and check with that.
If a simple column name works, there would be an issue with how n8n is sending special characters to Supabase
1 Like
Hey @hrishikesh
I tried your suggestion, but for some reason it did not work.
I’ve made a quick vid showcasing what is the setup https://vento.so/view/3fd10cd0-747c-4060-80b1-33f1494927a3?utm_medium=share
Sorry, I thought we were working with null and not empty. Those are 2 different things. To filter out empty, we would have to go back to your previous setup, like this:
This is how my database is now:
Here’s the workflow:
2 Likes
Hey @hrishikesh,
Now it works.
Thank you so much!!! And one last question, is there a documentation on that? I was looking around the internet & documentations from n8n & perplexity etc ,but I could not find answers it until now?
Teste it both ways:
Option 1:
and
For the next person that’s having the same issue:
- Make sure that the Column name is Simple (eg. Phone and not Phone #1)
- Make sure to add “.” and the end
I don’t have any specific documentation other than: Tables and Views — PostgREST 12.2 documentation
Basically, the dot at the end of eq. is a part of the PostgREST query syntax. It acts as a separator between the operator (eq) and the value being compared. So I just tried leaving it empty after the . and it worked.
1 Like