search

parcelvoy / platform

Parcelvoy: Open source multi-channel marketing automation platform. Send data-driven emails, sms, push notifications and more!
https://parcelvoy.com
Other
182 stars 31 forks source link

Searching for users does not work #420

Open mattes3 opened 3 months ago

mattes3 commented 3 months ago

I have a user named "Matthias". When I enter an "a" inside the search box above the list of users, I get the message "No results".

pushchris commented 3 months ago

User search is not a fuzzy search by design currently, it only does exact comparison for email, ID and phone. The name field isn't searchable at all as its not an indexed field and only exists inside of a JSON document of properties associated to the user

mattes3 commented 3 months ago

Could you change the exact equality operator to an ILIKE, at least?

i.e. WHERE email ILIKE '%substring%'?