Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Oracle Apex Hierarchical Data View

I am creating a pretty basic CRUD application with Oracle Apex. I simply want to create a hierarchy based on some logic that spans 4 tables all on one page. In our current application which we are trying to convert to Oracle Apex we have a list of nodes that when we click on them we can display their children tables in the main view.
Lets say we have 4 tables, each with Primary Keys that relate to one another. How do I display certain values from these tables on the page all at the same time? I have tried some of the wizards that Apex provides but with no success. I think it will have to be custom PL/SQL logic. The data has to be in a certain order as well.
1
2
3
4
How can I create a view similar to this?
Answers
-
1349b942-de7d-45f2-9543-7f91df6618e4 wrote:
Please update your forum profile with a recognisable username instead of "1349b942-de7d-45f2-9543-7f91df6618e".
Always include the information described in these guidelines when posting a question: how to get answers from forum
I am creating a pretty basic CRUD application with Oracle Apex. I simply want to create a hierarchy based on some logic that spans 4 tables all on one page. In our current application which we are trying to convert to Oracle Apex we have a list of nodes that when we click on them we can display their children tables in the main view. Lets say we have 4 tables, each with Primary Keys that relate to one another. How do I display certain values from these tables on the page all at the same time? I have tried some of the wizards that Apex provides but with no success. I think it will have to be custom PL/SQL logic. The data has to be in a certain order as well. 1234How can I create a view similar to this?
It's probably possible using a tree region and a classic report with a custom template. It depends on the data model and the structure of the HTML output (the semantics of which look questionable from what we can see so far). This cannot be determined from context-free screenshots.
Post the following information:
- Provide some background context, identifying the business/problem domain and the nature of the application.
- DDL for the tables involved, indicating the relationships between them if foreign keys are not defined.
- The HTML structures used for each component of the "main view".
Better still, create some sample data on apex.oracle.com and share guest developer credentials for the workspace here.