13.4 Managing Trees
Trees to display hierarchical information in a clear, easy-to-use format. You can create a tree control using a SQL query.
- About Trees
Tree controls in Oracle APEX use APEX Tree. - Creating a Tree Using the Create Page Wizard
Create a tree on a new page by running the Create Page Wizard. - Creating a Tree in Page Designer
Create a tree control by providing a SQL query that specifies a hierarchical relationship by identifying an ID and parent ID column in a table or view. - Editing Tree Attributes
Control tree behavior by editing region attributes and report Attributes.
Parent topic: Managing Application Controls
13.4.1 About Trees
Tree controls in Oracle APEX use APEX Tree.
App Builder includes a built-in wizard for generating a tree hierarchical navigation mechanism. Trees are implemented using a single hierarchical query that identifies the row to be used as the start of your query and the relationship between parent rows and child rows of the hierarchy. Trees use the APEX Tree implementation. This is a JavaScript-based, cross browser tree component that features optional keyboard navigation, and optional state saving.
When you implement a tree control, the SQL query specifies a hierarchical relationship by identifying an ID and parent ID column in a table or view. The tree query must utilizes a START WITH .. CONNECT BY
clause to generate the hierarchical query.
Tip:
The creation of APEX Tree regions is only supported on pages using a Desktop user interface.
About Desupported jsTrees
Prior to release 5.2, APEX supported the rendering of jsTree tree regions. APEX no longer supports jsTree tree regions. APEX now supports the generation of an APEX Tree tree region. APEX Tree is a JavaScript based, cross browser tree component. jsTree regions are automatically upgraded to APEX Tree regions when upgrading from a previous release or when importing to release 18.1.
Tip:
To view tree examples, install the sample app, Sample Trees. To learn more, see Installing Apps from the Gallery.
Parent topic: Managing Trees
13.4.2 Creating a Tree Using the Create Page Wizard
Create a tree on a new page by running the Create Page Wizard.
To create a tree on a new page:
Parent topic: Managing Trees
13.4.3 Creating a Tree in Page Designer
Create a tree control by providing a SQL query that specifies a hierarchical relationship by identifying an ID and parent ID column in a table or view.
START WITH .. CONNECT BY
clause to generate the hierarchical query.
To create a tree in Page Designer
Parent topic: Managing Trees
13.4.4 Editing Tree Attributes
Control tree behavior by editing region attributes and report Attributes.
By default, a tree does not have focus and node links are activated with a single click action.
To access the Tree attributes:
Parent topic: Managing Trees