Oracle APEX changing the colour of display only item with PL/SQL query

user_9439634 0
Viewed 3493

I have a display only item in a static content which looks like this:

enter image description here

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.

oracle-apex oracle css sql html
1 Answers

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.

user_41782620
Related