How can I tell RPE to deliver HTML as HTML and not as Plain Text for RB Query result

Erwin Kunz (946●8●70●86) | asked Aug 30 '16, 3:10 a.m.

CLM6.0.2
RPE 2.1

I've created a query with report builder to return Workitem ID, summary and description.
Exported the DTA, DSX and use both in RPE
All fine except that the description comes as plain html code.

result/result/Description is what is returned and this seems to be HTML

up to now I was used to create connection and query directly in RPE and description was
workitem/Description/_value and was plain text without HTML coding

Is there a way to tell RPE that this value is HTML and to be handle as. Or a way to transform the text

thank you

2 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Erwin Kunz (946●8●70●86) | answered Aug 30 '16, 10:47 a.m.
edited Aug 30 '16, 10:51 a.m.

Hi all

I finally found the solution.

My text was like:

cause a reset.<.br ></.br>Customer a

1) created a variable MyDescription
2) Assigned Description to MyDescription with XHTML Input not selected and XHTML Output selected
3) use MyDescription in the report

Comments

Hutter Donat commented Aug 31 '16, 3:03 a.m.

permanent link

Subramanya Prasad Pilar (4.6k●1●6) | answered Aug 30 '16, 8:26 a.m.
edited Aug 30 '16, 8:27 a.m.

In the template, you should use Script Expression with "XHTML Input" and "XHTML Output" options checked. You can use JavaScript to remove/replace the tags as in the screenshot.
ScriptExpression

Comments

Erwin Kunz commented Aug 30 '16, 10:55 a.m.

Thank you
I surely a solution today. But as I understood, it will be a real rich text editor in the near future

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

It's all about the answers!

Related questions

How can I tell RPE to deliver HTML as HTML and not as Plain Text for RB Query result

2 answers

Your answer