APEX

Hi,

I am trying to change the font color based using a CASE statement the query as below:

select "ORDER_ID", 
"ORDER_REFERENCE",
"ORDER_DATE",
"ORDER_SOURCE",
"TOTAL_DISCOUNT",
"DELIVERY_TYPE",
"PICKUP_DATE",
case
	when order_status = 1 then '<font color="red">'|| order_status||'</font>'
	else
	'<font color="blue">'||order_status||'</font>'
end order_staus,
"DELIVERY_STATUS",
"USER_ID",
"CUSTOMER_ID",
"SITE_ID"
from "ORDERS" 
 

I can get this to work by selecting Standard Report Column in the column heading type. However this mean I can't use LOV as LOV options involve removing HTML characters.

Is there a way I can conditionally change the font with query above and use LOV as well? Thanks.

Environment

Apex 4.1.1 at apex.oracle.com
Theme 13

Edited by: taepodong on Jun 3, 2012 7:28 AM