Hello,
I have an apex tree which retrieves all the properties in the database
SELECT status, level, name, icon, id, tooltip, link
FROM table_properties
WHERE ...
START WITH...
CONNECT BY PRIOR id = pid
ORDER SIBLINGS BY ...
and I want to be able to click on this table's leaf nodes and see some columns which are also in table_properties (for example creation date and user). These 2 fields should appear as child nodes of the leaf nodes.
Is there any way I could do that?
Thank you for the help!