Disconsider accentuation on Oro search

Hi Oro team!

Currently, Oro search brings to me (in whole system) different results if I look for “João” and “Joao”.

How to change it and make Oro disconsider accentuation on search, datagrid, form fields (<select> tag), reports (inside SQL query executed by report)?

Topic

[Yevhen ShyshkinParticipant]

Hello, William.

Oro applications work with UTF8 charset which means that “a” and “ã” are different characters. To make it work like you want you have to change every place where it does not work the way you like.

If you’re using Enterprise Edition and Elasticsearch then you may change default analyzer configuration and add there asciifolding or icu_folding filters. It will cover global search and most of the autocompletes (select form fields).

As for the datagrid and report filters – here you have to work directly with DB filtering. DB filters are encapsulated at filter classes – e.g. StringFilter. You can override / decorate some of such filters and wrap your column and input into one of the string convert functions which will convert UTF8 e.g. to ASCII. There are two issues here – you’ll need to write (or find) Doctrine function for your conversion, and filters most probably will not use DB indexes so such filtering will be slower.

[William RadiParticipant]

Hmmm

Ok… Thanks, Yevhen! :D

[am”>ine.behwanParticipant]

CLICK

• This reply was modified 5 years ago by  am">ine.behwan.

[Author]

Replies