All,
I created a tree and all looks good but iam trying to set the font color of a node as show below but it wont work, can somebody pls give me a solution where i went wrong here,
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
'<SPAN style="color:red;">' || "ENAME" || '</SPAN>' as title,
(case when level = 1 then '#IMAGE_PREFIX#Fndtre11.gif'
when level = 2 then '#IMAGE_PREFIX#Fndtre12.gif'
else '#IMAGE_PREFIX#Fndtre13.gif' end) icon,
"EMPNO" as value,
null as tooltip, url as link
from EMP
.......
apex 4.1.1
thanks