Loading...
Loading...
List Reports show raw HTML tags such as <p>. In the list view the tags are hidden from the HTML field content.
Log in and navigate to Reports > View/Run. Click on the button 'All'. On the Report's search box search for "knowledge". Click on 'Knowledge created by Author'. Change the report type from Trend to List. In the Configure tab, click on Choose columns Add the Text field to the report by moving it from the Available to the Selected slushbucket. Click on the button 'Run'. Click on the arrow to the right side of 'Author: Boris Catino'. Note that the Text column contains HTML tags. Open 'Author: Boris Catino' on a new tab (right-click on it and select Open on a new tab). Note that the Text column does not show HTML tags.
This is working as designed in all current versions. The workaround/enhancement described below requires the creation of a new string field on the target table, which in this example is kb_knowledge. The background script in step 2 is used to strip the markup from the HTML field value and save it into the new string field. It does this for all existing records. The before insert/update business rule in step 3 is to apply the same process to new and updated records. Now the plain text field can be used for reporting and lists. Create a string field on kb_knowledge with max length 65000 Run the following background script, after adjusting the table and field names: var kb = new GlideRecord ( 'kb_knowledge' ); kb.addNotNullQuery('text'); kb.query(); while ( kb.next() ) { var html = kb.text; //HTML field html = html.getHTMLValue(); var doc = GlideXMLUtil.parseHTML(html); var b = doc.getDocumentElement().getTextContent().trim(); kb.u_plain_text = b; //u_plain_text is the new string field kb.update(); } Create a before insert/update business rule on kb_knowledge with the following script: (function executeRule(current, previous /*null when async*/) { var html = current.text; //HTML field html = html.getHTMLValue(); var doc = GlideXMLUtil.parseHTML(html); var b = doc.getDocumentElement().getTextContent().trim(); current.u_plain_text = b; })(current, previous);
PRB1066380
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.