Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

Facing issue while retrieving text using fetchxml

Posted on by 30

Hi,

We are facing issue while retrieving text using fetchxml.

Scenario: We have implemented search bar using angular in which we have to search for a word or any other symbols and need to highlight that word or symbol.

We are retrieving the description field value that is present on the email entity. This field is a Microsoft OOB control which is Rich Text Editor to add font size, color, images, and so on. It stores data in html format.

Problem: Whenever we search in description it searches in the html as well, which should not happen.

E.g. In the below email description, the slash or div are present in the background value but not on the front end value.

 pastedimage1674036597460v1.png

If we search “/” or “div” then above email is also retrieving.

We want to retrieve only those emails who has “/” or “div” present in their text and not in the html.

We thought to store the innertext value in a new field. For retrieving we use that value.

E.g. retrieve email contains ikl_plaindescription eq “/”.

For highlighting the text we are replacing the searched value with <span style= “background-color :yellow”> searched value </span>.

Because the html contains ”/”, the slash before the closing div tag also gets replaced which in turn generate incorrect html

We tried using few regex expressions which didn’t help.

Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans