working at apex.oracle.com
had an Interactive Report, a column cell should conditionally present, the query is here but it is highlighting only text background not complete Cell, what i am missing? i have selected Block color from oracle apex universal theme color and status modifiers. please help.
the sql statement:
select ID,
USER_ROLE,
USER_NAME,
INVESTMENT_POOL,
INVESTED,
START_DATE,
CASE WHEN USER_ROLE = 'E' THEN 'u-color-7'
WHEN USER_ROLE = 'I' THEN 'u-color-31'
WHEN USER_ROLE = 'A' THEN 'u-color-9'
ELSE NULL
END CSS_STYLE
from CF_USERS_INVESTMENTS
and in HTML Expression of this column:
<span class="#CSS_STYLE#">#USER_ROLE#</span>
output:
regards