I have a hierarchical query spanning four levels over two tables. The query works great and also includes hierarchical sum columns (i.e. the parent shows the sum of all children) using functions.
I'm wondering what the best way to display this data to users is?
At the moment I'm thinking I would have a collection holding my report with an extra 'show' column. Then I would include HTML to set the correct show/hide values and refresh the report when a node is clicked. I feel this would probably work but it can't be the best way.
I stripped down my query to the columns needed (no sum columns) and the APEX tree regions work nicely for this. Is there any alternative jquery plugin or anything that people have experience with that will give me the native 4.2 tree structure whilst also allowing me to display extra columns with links?
If I need to provide any more info just let me know!