Question

1
Replies
34
Views
vishruthi reddy (vishruthir3555)
Societe Generale Energie USA Corporation

Societe Generale Energie USA Corporation
FR
vishruthir3555 Member since 2017 4 posts
Societe Generale Energie USA Corporation
Posted: April 6, 2021
Last activity: April 20, 2021
Posted: 6 Apr 2021 4:55 EDT
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 pyDescriptionActivité 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

 

Pega Platform 8.3 Case Management Financial Services Lead System Architect