Hello all,
I'm pretty new (in fact, completely new) to ADF Development so bear with me here.
I'm using JDev version 11.1.1.7.0
My question is as follows:-
I've got a single table, with a single entity object and a read-only view object, metaphorically, sitting on top of it. This table contains attributes such as System Type, Application Name, Message Content, etc. This is used as an audit trail repository for many applications within our domain.
Now what I want to do is create a tree-table style menu to allow the user to select a System Type (there won't be many of these) and traverse Application Names that are linked to the selected System Type. I do not need to take the granularity down any further than the Application Name. When a user clicks on either the System Type or a given Application Name, the ADF table component that I have on my .jspx page should perform a partial page refresh to filter the results accordingly.
This is what I envision the tree-table to look like:- The user should be able to expand and collapse the nodes as required.
<System Type>
<System A>
<Application Name A.1>
<Application Name A.2>
<Application Name A.3>
<System B>
<Application Name B.1>
<Application Name B.2>
<System C>
<Application Name C.1>
etc.......
I've done a bit of research and I'm not sure I am able to achieve what I require using a single view object. Lots of the articles and tutorials I've read up to now focus on view objects that contain link relationships with one or more view objects. This obviously creates a master-detail relationship which is readily available for traversal I'm guessing...?
Any help would be greatly appreciated.
Thanks,
Jimbob