1,627 questions

3,174 answers

1,701 comments

477 users

html tags in notes column in ad hoc query

0 votes

Hello All

We are retrieving sponsorship "Notes" in an ad hoc query.

When we enter the notes using CRM webui we have a rich text (html) editor.

When we see the column retrieved in the ad hoc query all the html tags have been stripped out.

Is there a way to preserve the tags? I can see that the webui is preserving the tags.

Thanks in advance for looking and having a think!

asked Sep 18 by nightand (113 points)   1 7
edited Sep 18 by nightand

1 Answer

0 votes
 
Best answer

I would think no, but am not 100%. I'm betting that the html is encoded therefore it won't be shown in the display.

answered Sep 18 by chriswhisenhunt (3,803 points)   8 23 43
selected Sep 18 by nightand

The problem is that the ad hoc query is being used by ajax in BBIS (using BLACKBAUD.api.QueryService) and the column appears to have had the tags stripped out when retrieved that way as well. It would be good if the markup made it through to BBIS. But I'll take this as a "no". Thanks for your help!

...