Highlighting a Tree View Entry

Previous Next

See Also

You can highlight a tree view entry by adding an additional column to the query of a tree view node. This results in the entry being displayed in a bold font type.

The additional column must get the "TREE_HIGHLIGHT" alias. When the retrieved column value is NULL, the entry is displayed in the default way. When the value is not NULL, it is displayed highlighted. For example:

SELECT  p.prompt

       ,DECODE(count(c.FK), 0, NULL, 1) "TREE_HIGHLIGHT"

FROM    PARENT p, CHILD c

WHERE   p.PK = c.FK

GROUP BY p.prompt

In this example, the prompts of parent records that have child records are highlighted.