Search code examples
htmlsqloracle-databasebi-publisher

How to embed HTML content in BI report for bursting?

I want to send HTML Email from BI publisher, but the HTML is not getting recognized by the SQL query and it is trying to interpret it further.

How can I make use of that HTML as a literal with dynamic values returned by the query?

Solution

  • You can make use of htf.escape_sc() function which will take care of escaping HTML. It will use HTML entities internally. e.g. < will get converted into &lt;