This topic contains the following sections:
A user needs to be able to drill down into a tree of hierarchical data and when selecting the terminating node in this tree will see some detail of the children of this collection in a table to its right and additional detail of the selected row in a form below.
The Master-Detail-MoreDetail pattern provides an ADF Tree to display the Master information, an ADF Table showing some Detail of the children of the terminating node selected in the tree and an ADF Form showing more detail of the item selected in the Table. See the User Experience section below for a screenshot of the user interface from the pattern prototype.
Drill down into the Tree and select the desired terminating node (Departments, in this case). When the user selects the desired Department, the Table to its right will refresh to display the Employees for this Department, showing some detail of each Employee.
View more detail of target Employee. Now the user can select the desired Employee from the Table and see additional detail information for this employee in the Form below.
Following is a list of the artifacts used in this pattern.
ADF BC Model Objects
User Interface Elements
Note: This sample implementation of this pattern uses the HR schema in the oracle demo database.
The implementation of the Master-Detail-MoreDetail pattern can be broken down into 3 fundamental elements:
Note: Unless otherwise instructed, accept the ADF Wizard defaults options.
Use the following where causes…
RegionsView where clause:
region_id in (
from countries C, locations L, departments D
where C.country_id= L.country_id and
CountriesView where clause:
country_id in (
from locations L, departments D
where L.location_id= D.location_id)
LocationsView where clause:
location_id in (
select location_id from departments)
Note: If you run your page at this point, the Tree will expand properly, but the Employee data in the Tree (and Form) will not change when you select a Department node. For example, select the Finance Department under Americas > United States of America > Seattle. This is because we have not setup a Target Data Source for the Tree or setup Partial Refresh using Table’s PartialTriggers property.
|Documentation Related to the Pattern Artifacts|
|ADF Business Components||Creating Entity Objects and Associations in the Fusion Developer's Guide for Oracle ADF at http://download.oracle.com/docs/cd/E14571_01/web.1111/b31974/bcentities.htm#ADFFD160|
|Application Module||Creating and Modifying an Application Module in the Fusion developer's Guide for Oracle ADF at http://download.oracle.com/docs/cd/E14571_01/web.1111/b31974/bcservices.htm#ADFFD1493|
|Documentation Related to Pattern Implementation Steps|
|Data Controls Panel||Using the Data Controls Panel in the Fusion Developer's Guide for Oracle ADF available at http://download.oracle.com/docs/cd/E14571_01/web.1111/b31974/bcdcpal.htm#ADFFD502|
|ADF Tree||Displaying Data in Trees in the Web UI Developer's Guide for Oracle ADF available at http://download.oracle.com/docs/cd/E14571_01/web.1111/b31973/af_table.htm#ADFUI225|
|ADF Table||Displaying Data in Tables in the Web UI Developer's Guide for Oracle ADF available at http://download.oracle.com/docs/cd/E14571_01/web.1111/b31973/af_table.htm#ADFUI207|
|Partial Page Refresh||Enabling Partial Page Rendering Declaratively in the Web UI Developer's Guide for Oracle ADF available at http://download.oracle.com/docs/cd/E14571_01/web.1111/b31973/af_ppr.htm#ADFUI389|
In order to test this pattern out, included is a JDeveloper 11g Application called master-detail-moredetail that can be unzipped into your designated work area and explored / executed from within JDeveloper, Simply download master-detail-moredetail.zip, unzip the archive, open the mdmd.jws with JDeveloper 11g and explore. The download is available at http://www.oracle.com/technetwork/developer-tools/adf/master-detail-moredetail-131676.zip