Question
Societe Generale Energie USA Corporation
FR
Last activity: 20 Apr 2021 4:36 EDT
Elastic Search how to perform an accent insensitive compare (e with è, é, ê and ë)
In Pega 8.3 ,We are using Elastic search to search work objects on particular fields defined in 'custom search properties' We are using this feature to search work objects with some texts and get results.
example field pyDescription
Scenario : Case ABC-1 has pyDescription = Activité des personnes
If the search text = Activité , Then ABC-1 case is shown in result list
If the search text = Activite , Then ABC-1 case is expected to be in result , but since the é is not in search text it doesnt show ABC-1 in result.
How can we perform accent insensitive search, in postgre we can use COLLATE French_CI_AI can we use something like this
Regards
Vishruthi