so in my MYDBR reports, I have a particular column which has data containing plain text values for certain rows , whereas it also has html tags and plain text in some rows. I Want to know what's the best way to render the data on frontend as html and not plain text .
the column contains data in similar format - "some text some url some text "
I tried below attached code snippets however they don't work as expected .
1) select tablename.columnname as 'dbr.html:columnname ';
2) select 'dbr.html', 'columnname ';
select 'dbr.url', 'columnname ';
Please suggest a way to achieve this in mydbr?