Hierarchical ADFTree with JDeveloper 11g

Erwin Vrielink 6
0 0
Read Time:2 Minute, 16 Second

There are different manners to display hierarchical data. One of the most intuitive ways is using a tree structure like a file browser. This enables the ability of simple navigation without losing the context. The brand new JDeveloper 11g offers a very impressive set of Rich Internet Components. One of these components is the ADFTree component, for presenting this kind of information.

For a little demo we use the Employees table standard shipped with the Oracle Database.

Starting point is a new Fusion Web Application with a Model and ViewController project. Create for the HR.EMPLOYEES table the default EntityObject (Employee) and ViewObject (EmployeeView). The association and the viewlink for the pig’s ear is automatically made.

Inspecting the data form SQL with an hierarchical query:

select rpad(' ', level*3)||emp.first_name||' '||emp.last_name
from employees emp
connect by emp.manager_id = prior emp.employee_id
start with emp.manager_id is null

The start with clause filters only the root-nodes shown on top of the tree, in this case only “Steven King”. When presenting this data in an ADFTree we also have to filter the root-nodes. One way to do is to add a new ViewObject (RootEmployeeview) for selecting only the root-nodes. Use “Employee.manager is null” for the where clause. Also we have to define the relation between the manager and themanaged employees. By defining the accessors for the link pay attention to the Accessor name for the destination. This accessor name must have a different name than in de default created link for the pig’s ear. Don’t forget to add the new made ViewObject to the application module. The data model must look like:

This is all for the model. In the View project add a Panel Collection on the page. This panel collection adds some extra functionality as collapsing the tree. Now it’s time to drag the RootEmployeeView from the Data controls on the Panel Collection. Choose ADF Tree in the populated poplist and define the bindings for the Tree.

Tree Binding

The result is a full functional Tree with all the employees presented.

Result

For adding extra functionality you can add a select listener to the Tree component. To do this select the Tree on the JSF page and add a Selection listener which calls a backing bean method. Extract the selected rowkeys from the event and retrieve the data.

  public void TreeNodeSelected(SelectionEvent selectionEvent) {
    RowKeySet rks = selectionEvent.getAddedSet();
    if (rks != null) {
      System.out.println("Selected Employees:");
      // multiple values in case of rowSelection="multiple"
      RichTree fowTree = (RichTree)selectionEvent.getComponent();
      Iterator iter = rks.iterator();
      while (iter.hasNext()) {
        fowTree.setRowKey(iter.next());
        FacesCtrlHierNodeBinding rowData = (FacesCtrlHierNodeBinding)fowTree.getRowData();
        System.out.println(" - " + rowData.getAttribute("FirstName") + rowData.getAttribute("LastName"));
      }
    }
  }

About Post Author

Erwin Vrielink

Oracle Consultant at AMIS
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

6 thoughts on “Hierarchical ADFTree with JDeveloper 11g

  1. Do you have a zip with this example?
    I am trying to figure out how to specify the  model objects for this, especially the links?

  2. Hi

    Thanks a lot for your sample, Could you tell me populate a tree with parameter, it means my queries accept parameters, I could not populate this tree, just the first row has been generated!!!!!

    Thanks again.

Comments are closed.

Next Post

Mr. Thomas Kyte goes Dutch - Guru4Pro

  We Dutchies are in luck. Mr. Thomas Kyte will be in Holland on the 3th of November presenting "11 Things about 11g" on the Logica premises during a Logica Guru4Pro event in Amstelveen. Besides this presentation, there will be the opportunity to askTom the questions you always wanted to ask him. You […]
%d bloggers like this: