Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implementing 3 level tree in Apex

JJINOct 5 2010 — edited Dec 22 2010
Hi Friends,

I am trying to create a tree in apex. I am having 3 tables.
1.Client

2.Location

3.Device. 
I am having an materialized view "device_detail_view" with columns "device_id","location_id","client_id". This

Mview is having the "location_id" and the "client_id" for all devices. The corresponding client_name and location_name

is stored in the tables "client" and "Location". I want a tree in which the "Client_name" will be the root node. When

clicking on the client names all "location_name " assosiated with that need to be displayed. When clicking on a specific

"location_name" all "device_name" assossiated with that device must be displayed.How can i achieve this. Any input will

be appreciated.

Regards,
Jyothi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2011
Added on Oct 5 2010
2 comments
760 views