Weblog for the AMIS Technology corner
Posts tagged rollup
ADF 11g – TreeTable with sub totals – how the SQL query can make life easier for the View developer
Dec 1st
The ADF 11g Tree Table component can be used for the compact presentation of fairly complex data sets. It allows the user to quickly drill down to a specific area of interest. For example to find all Roles within a specific Department and for any Role all Employees in that role.
On many occasions, it may be desired to show sub-totals at the various levels in the tree. For example in the way shown in this screenshot:
In this article we will see how we can achieve this fairly easily, by creating a ViewObject with a SQL query that does most of the heavy lifting.
