This content has been marked as final. Show 3 replies
Pre-Apex4 you could make use of the A1 and A2 columns in the tree SQL along with the tree template to conditional set the color of the node text. Does anyone know how to achieve this in Apex4? I've tried using the tree SQL shown below but this displays the HTML (SPAN tags) as text.
Any assistance would be appreciated.
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, null as icon, "EMPNO" as value, null as tooltip, null as link from "#OWNER#"."EMP" start with "MGR" is null connect by prior "EMPNO" = "MGR" order siblings by "ENAME"