Fuzzy Search little problem

Wappler General Need Help
1

Is there a way to get the fuzzy search to show results no matter if there is a capital letter or not.
For example in the DB I have Albert
Now if I search with fuzzy search for Albert then it works, but if search for albert it does not show.

Anyone got any ideas?

2

Hello, you can apply “To Lowercase” formatter to both the search value and the property you are searching in. This way it will not be case sensitive.

2 Likes
3

Hi @gunnery & @Teodor,

I manage to lowercase my filter value, but where do you apply it on the “property you are searching in.” as one cannot edit the query to set a column to lowercase.

Regards,

Nick

4

Select the value and then it (+) and add convert to lowercase on both the property and the value.

00%20pm
Screen Shot 2019-05-01 at 9.18.00 pm.png361×621 22.2 KB

5

@gunnery thank you for reply. but where do you do that, in the server connect section, or the server connect in the app structure section or some where completely different?

6

Sorry for the delay, but I’m in. Australia so it was night time when I replied and now its early in the morning. I know how frustrating it can be waiting for answers.
Easy way to see it watch the video below. I’ve done a recreate of fuzzy search on a query.

Hope it makes sense.

fuzzy.mov (45.8 MB)

7

Hi @gunnery,

Thank you for your time in creating a video, it did help in understanding. although it did not work for me(when trying to load the property to add a value, it keeps on loading).

But I did find a different way for my use case. Because I use a PostgreSQL DB, i had to add CIText extention(case-insensitive text data type), which solved my problem.

Regards,

Nick

8

all good, at least its working now :slight_smile:

9

@pheaxx how did you manage to apply the „citext“ type to your columns? I was able to install the extension but wasn‘t able to apply the type to my column via the ui.

Could you give me a hint?

10

I don’t use Wappler for database changes, I use Navicat for Postgres. but you can use also pgAdmin4, with either you then can set citext as a column type in your tables.