ADF DVT Speed Date : Meeting The Hierarchy Viewer

Luc Bors 5
0 0
Read Time:8 Minute, 42 Second

Recently the ADF Special Interest Group at AMIS organized an ADF DVT Speed Date. During this speed date, six ADF specialists from our team presented their favorite Data Visualization Component from the DVT library. In a series of blog posts we share the information with a broader audience. In this post you get introduced to the Hierarchy Viewer – which was my own date for this party.

Introduction : The Hierarchy Viewer

A Hierarchy viewer is typically used to display hierarchical data. Examples of this are for instance a tree of life or a mindmap or even a family tree. Image Image

The ADF hierarchy viewer consists of several ADF components.

  • dvt:hierarchyViewer : This element wraps the dvt:node and the dvt:link elements
  • dvt:node : The dvt:node element supports the use of one or more f:facet elements that display content at different zoom levels (100%, 75%, 50%, and 25%).
  • dvt:link : connects one node with another node
  • dvt:panelCard : The panel card element provides a method to dynamically switch between multiple sets of content referenced by a node element using animation by, for example, horizontally sliding the content or flipping a node over.

A hierarchy viewer component requires data collections where a master-detail relationship exists between one or more detail collections and a master detail collection. The hierarchy viewer component uses the same data model as the ADF Faces tree component. When you add a hierarchy viewer component to a JSF page, JDeveloper adds a tree binding to the page definition file for the JSF page.

Image

Lets start with creating a simple hierarchy viewer.

Hierarchy Viewer: The basics
A hierarchy viewer component can be used to visually display hierarchical data. Hierarchical data contains master-detail relationships within the data. For example, you could create a hierarchy viewer component that renders an organization chart from a data collection that contains information about the relationships between employees in an organization. Let’s do that. Create a new ADF Enterprise application in JDeveloper.

Creating the Business Components Create ADF Business Components from tables. These Business Components will be used as basis for the Hierarchy Viewer. The connection for this application needs to point to the DVT_USER. (you can use the HR schema as well if you like. If you do, then don’t use the table prefix LBO that I used in this example)

Image

 

1. Skip the first couple of steps in the wizard. In this hands-on we will use read only view objects

2. In step 3 of the wizard (creation of read only view objects) adjust the package name if you want to.

3. Shuttle the LBO_EMP_DETAILS_VIEW to the right. This view contains all the data that is needed for the hierarchy viewer. Rename the instance to EmpDetails

Image

In the next step, create an application module. This is the Application module that is used in this application.

Image

Finish the wizard.

Connecting the employees

In the data in this hands on each employee has a manager (or not). This relationship is used in the hierarchy viewer to display employees as a child node of their manager. To make this work, a we need a view link. 1. Create a new viewlink to connect employees and managers. This link is necessary to be able to display hierarchical data.

Image

Select the EmployeeId and the ManagerId and add the viewlink.

Image

Accept all the defaults and click finish.

Defining the root node

The hierarchy will have one root node. This root node is the node that depicts the highest level of employees. In this case it is the employee with no manager. In order to find the rootnode, you have to create a viewcriteria.

Image

With the viewcriteria created, it is now time to tell the viewobject usage to use this viewcriteria.
Open the application module data model. Step one is to add the employees viewobject usage as a child to the existing viewobject usage.

Image

Step two is to change the EmpDetails usage and add the isRoot viewCriteria. Select the EmpDetails usage and push the “edit” button. In the ViewCriteria dialog shuttle the isRoot criteria to the right.

Image

Now the Business Components part is finished.

Creating the “visible” part.
After finishing the business components it is now time to create the visible part of the hierarchy viewer application. For this you need to create a new page to hold the hierarchy viewer component.

Image

Select the EmpDetails collection and drag it from the datacontrol on to your page and drop it as an hierarchy viewer.

Image

JDeveloper now shows you the hierarchy viewer wizard. In the wizard select the vertical top down layout for the viewer.

Image

In the next part of the wizard you need to create the hierarchy. Check all the checkboxes in order to get the hierarchy viewer’s data. Leave the other zoom levels for now. We will get to that later.

Note that JDeveloper added several attributes to display by default.

Image

Click OK to finish the wizard.

Run the application and expand some nodes in the viewer

Image

Supporting different zoom levels
As mentioned erarlier, the hierarchy viewer supports different zoom levels. These zoom levels are implemented by facets.

Image

There are several ways to add the facets for extra zoom levels. You can go into hierarchy viewer declaration and enable the zoom levels and add the attributes that you want to display.

Image

However, there is a somewhat more convenient approach. This is by recreating the hierarchy viewer with a different layout. Let’s do that now. Start with creatin a brand new page.

Image

Drag and drop the same (EmpDetails) collection on to the page.

Image

Now select the other quick start layout on the bottom of the wizard.

Image

You will see the hierarchy viewer is now preconfigured somewhat different.

1. First you see an Image dropdown box. You can use this to add an image to the hierarchy viewer (duh). Select the employeeId attribute in the dropdown box in order to create an image based on the employeedId. This will not work, however it prepares the hierarchy viewer to use the image. We will fix that later.

Image

Another thing that is different you see when you open any of the zoom levels. JDeveloper already added some of the attributes to the zoom level facet. The only thing you need to do is to actually add the zoom level to the hierarchy viewer by checking the box.

Check the boxes for all the ‘lower’zoom levels.

Image

Finish the wizard by clicking OK.

JDeveloper created a hierarchy viewer with an image. This is implemented by the following code fragment.

 
<af:image source="#{node.EmployeeId}" 
          inlineStyle="width:85px;height:120px;"
          id="i1"/>

Replace that with

 
<af:image inlineStyle="width:108px;height:120px;"  
          source="/resources/images/hv/#{node.EmployeeId}.png"
          id="i1"/>

You can use any images as long as you put them in a folder called “/resources/images/hv/” and place this under the PUBLIC-HTML folder. Or better, as long as the source attribute knows where to find the images… On the file system it should look like this:

Image

Now you will see the image that corresponds to the employee. Feel free to rename the images if you don’t mind to show an image that is not actually displaying the real ‘face’ of the employee. Run the application, zoom to 100% and see what happens

Image

Changing panelcard transition effects

The hierarchy viewer has several panelcards. The transition from one panel card to another can be animated in different ways.

Image

 

Play with the property and see the effect. Maybe even implement a dropdown in your application so the end user can change the effect at runtime. This is not described in the hands on; You need a selectoneChoice (can be hardcoded), a managedbean, and set the effect property to something like “#{mybean.myEffect} Note that in 11gR2 there is an extra value called “cube” which adds even more animation.

Adding search functionallity

The search function in a hierarchy viewer is based on the searchable attributes or columns of the data collection that is the basis of the hierarchy viewer data model. Using a query results collection defined in data controls in Oracle ADF, JDeveloper makes this a declarative task. You drag and drop an ExecuteWithParams operation into an existing hierarchy viewer component on the page.

Preparing Business Components

1. Create a view object that performs the search.

Image

Image

Image

Finish the wizard.

Now expose the viewObject in the application module.

Image

On the empDetails view object we also need to create a bindvariable. This is the one that is used to navigate to the node that was found by the search operation. Go to empDetails and create a bindvariable.

Image

Adjust the where clause in the empDetails to take on the bindvariable.

Image

Create a databound search with a hierarchy viewer:

1. From the Data Controls panel, select the EmployeesSearch and expand the Operations node to display the ExecuteWithParams operation. If you don’t see it, refresh the datacontrol palet. 2. Drag the ExecuteWithParams operation and drop it onto the hierarchy viewer in the visual editor or onto the component in the Structure window. Alternatively, you can drag the parameter onto the hierarchy viewer.

Image

3. In the Create Hierarchy Viewer Search dialog that displays, use the Add icon to specify the list of results to display in the Search Results panel, and specify the following for each result:

a. Display Label: Select the values for the headers of the nodes in the hierarchy. If you select <default>, then the text for the header is automatically retrieved from the data binding.

b. Value Binding: Select the columns in the data collection to use for nodes in the tree for the hierarchy viewer.

c. Component to Use: Select the type of component to display in the node. The default is the ADF Output Text component. d. In the Operation dropdown list select the hierarchy root data collection to use when a search result is selected:

d. ExecuteWithParams: Sets the values to the named bind variables passed as parameters.

4. In the Parameter Mapping table, use the dropdown list in the Results Attribute column to select the results collection attribute to map to the parameter displayed in the Hierarchy Parameter column. In this hands on we need EmployeeId.

Image

 

Now restart the page and see the search at work.

Image

Resources

The information used in this post can be found in the ADF Developerguide here.

About Post Author

Luc Bors

Luc Bors is Expertise Lead ADF and technical specialist/architect at AMIS, Nieuwegein (The Netherlands). He developed several Workshops and training on ADF and also is an ADF and JHeadstart instructor. Luc is a member of the ADF Methodology group and publishes articles on ADF in oracle technology related magazines, on the AMIS technology blog, (http://technology.amis.nl/blog).
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%

5 thoughts on “ADF DVT Speed Date : Meeting The Hierarchy Viewer

  1. Hi Luc Bors,

    Wonderful article. Can you please come up with a sample ADF project of family tree.

    Create table family_tree(
    id number,
    name varchar2(120),
    father_id number,
    mother_id number);

    Both father_id and mother_id are foreign keys to id column.

    It would be a great help.

  2. For some reason the search facility only works in the Flash version, if you run this with Flash diabled no search facility. Any ideas, I have logged this with Oracle Support and waiting to hear back.

  3. Hi Luc,
    This is a very useful post and thanks for sharing your experience.
    I made a hierarchy viewer with the knowledge got from this post.I have two problems.
    1) When user mouse over a node how to make a tooltip to pops up?
    2) I have a description to be shown in each node. The relevant data column is of type VARCHAR2(45Byte) in the db. That data is not rendered in the view correctly. It shows only 18 characters followed by some dots.
    Ex:
    actual data – 012345678901234567890123456789012345678901234
    how it is shown in the view –
    012345678901234567…

    How can i show all the data. Better to go for multiple row option? Please help.

    Regards!
    Sameera

  4. Hi Luc,
    Have you tried to creat the Hierarchy viewer inside a JSFF page, in a dynamic region? It seems that the search funcionality doesn´t work inside a region with jsff page. Can you help me?

Comments are closed.

Next Post

Out of the box usage of ADF DVT Scheduling Gantt Chart to report Database Query Results using stacked bar charts per time period

Gantt Charts in ADF are interesting components to visualize data that is organized according to time. The Gantt Charts have a horizontal time axis. In rows along the vertical axis, resources or tasks are displayed. The cells in this time/resource matrix represent information about the resource or the task at […]
%d bloggers like this: