When calling apex_json.write to set boolean values, dont put the true/false in quotes. It generates a string and not a boolean value. If I look at the DOM for the tree, some of the boolean parameters are being processed as undefined as they are generated as a string
Include the is_leaf column in the SQL query (if you use the connect by statement to generate the tree structure. You can rather use this to check if the node has children, instead of running another SQL statement. This requires a change to all the variables that are used when looping through the columns.
Hi
Some performance enhancement suggestions:
When calling
apex_json.write
to set boolean values, dont put the true/false in quotes. It generates a string and not a boolean value. If I look at the DOM for the tree, some of the boolean parameters are being processed as undefined as they are generated as a stringInclude the
is_leaf
column in the SQL query (if you use theconnect by
statement to generate the tree structure. You can rather use this to check if the node has children, instead of running another SQL statement. This requires a change to all the variables that are used when looping through the columns.Regards, Shaun