I have a display only item in a static content which looks like this:
I want to change the whole background colour of the button/item instead of the text’s colour.
My PL/SQL code looks like this for example for the first item:
SELECT case ACTUAL_SITUATION when 'Y' then '<span style="color:green">Yes</span>' when 'N' then '<span style="color:red">No</span>' end as "ACTUAL_SITUATION " FROM tableName
Is it possible to change it with PL/SQL? All I could do is change the span background colour and that was just a highlight on the text.
Advertisement
Answer
Assuming you have a “Display Only” field, set the “Source” to be a “SQL Query(return single value)” and be sure to set under “Security”, “Escape special characters” to “No” to allow the HTML to flow through. Note that you want to use background-color
not color
in your style to set the background.
I tested it and it works.