I am using one of report plugin . but here have no "Escape special characters" option. so when i use color condition or use html/css in sql then it return value with html line. i attached a picture so that you can easily understand.
now my question is, how i escape special characters using by query in my apex or any other way to use escape special character.
Note: i uses a plugin here have not any type of attribute or option that i escape special character. google say, use APEX_ESCAPE, but i can't
Vinish Kapoor
Try to use the following regexp_replace() function expression for your table column containing HTML tags:
or
It will remove the HTML tags from it. Is this what you want?
RAJUDDX
thank you so much vinish for your reply. you are right, i want to same thing. but problem is, when i use regexp_replace then it return only value. not html color. when we create apex default report, then we off "Escape special characters" so that our column value show and conditional color also show.
but when i use regexp_replace then it show only value. not color.
.
this is my code
/*
case when p.PMANUFCODE="DRUG" then
regexp_replace('<span style="color:blue; font-weight:700;" >'|| p.PMANUFCODE||'</span>', '<.+?>')
else p.PMANUFCODE end as MANUFCODE
*/
here i want to my DRUG Value will be blue and others is default. but when i use regexp_replace then it show only value.
Vinish Kapoor
I don't know about your plugin, but I can suggest you one more thing.
Can you get two columns? One for display and one for formatting? Below is an example:
RAJUDDX
thank you vinish.
i am using "Pivot Table" Plugin which is created by "Morten Braten" .
here i want some modification. i want to dynamic pivot column so that use this plugin. but here this plugin have many limitation. i want to nested report in this plugin but cant, want to modify column nam, i cant and many thing.
but i see, this plugin is one of the best plugin for PIVOT REPORT