Hi Guys,
We are facing issue in searching emails having emojis.
Scenario: We have implemented search bar using angular, in that we have to search for emojis from the email description and highlight the searched emoji.
Here is the link from where we use emoji to copy & paste.
Searching emojis is giving us a problem that if we search any emoji it retrieves all the records with or without emojis. For retrieving we are using Xrm WebApi retrievemutiple method.
Below is the screenshot of the fetch we are using, while retrieving in fetch smiley comes which is searched:
Below is the record which contains emoji and the records which does not contains emoji:
We have found this same issue when searching from advanced find
We tried searching using Unicode value of the emoji, encoding the fetch as well as the emoji itself but it didn't help.
We also checked the description actual value using the OData query and found that CRM is storing the emoji in some text format.
We have highlighted the code in the below image
Decoding the value gives us the emoji
We have also serched using the encoded emoji text However, it doesn't return any record
We have also searched in SQL , there we observed that emoji is displayed
Any help would be appreciated.
Thanks