Home > User Voice > Autocomplete field type - Case (in)sensitive

Autocomplete field type - Case (in)sensitive

1

03.07.2023

15:54

Dear all,

I am wondering if there is no option for a case-insensitive search for fieldtypes like "Autocomplete" or "Choice field".
At the moment I am struggling to search for values with search mode "Contains". Unfortunately the search results differs based on beginning the search phrase with an upper or lower case.

In my opinion it would be a great benefit, if there are two addtional options (as checkboxes) to fine tune the search mode.
1) Ignore Upper and lower case --> case-insensitive
2) Ignore Whitespaces

If anyone knows an easy approach to achieve such a behavior in another way, I would look forward to get the information.
I think it has to be implemented in webcon.

Thanks a lot

Best regards
Thomas

03.07.2023

16:43

Hi Thomas,

I can't remember any case, where it was case insensitive. I just checked it again and it works fine.

Maybe your data source is a database with a case sensitive collation?

In this case you could add a view change the collation of the fields and use this view. Maybe you need to put the view also in a database with insensitive collation. If you need to go down this road, you could also add another column, where you remove the white space using sql functions. In the advanced configuration you would tick "searching" but wouldn't display it.

Best regards,
Daniel

Solution (1)

Helpful (0)

Wrong answer (0)

04.07.2023

08:47

In reply to: Daniel Krüger (Cosmo Consult)

Dear Daniel,

thanks a lot for your advise. It looks like, you are right. The primary source (db) is configured case sensitive. To be honest, I have never have heard about such options on DB level, but I am also no BD admin :)
In my case, I will try to change the settings and test it again.

Thank you

Best regards
Thomas

Solution (1)

Helpful (0)

Wrong answer (0)