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 Application Express use APEX Tree. - Creating a Tree on New Page
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
Developers can customize tree behavior by editing tree attributes.
Parent topic: Managing Database Application Controls
About Trees
Tree controls in Oracle Application Express 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, Oracle Application Express supported the rendering of jsTree tree regions. Oracle Application Express no longer supports jsTree tree regions. Oracle Application Express 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.
Viewing Tree Examples
To view tree examples, install the sample application, Sample Trees.
Parent topic: Managing Trees
Creating a Tree on New Page
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
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 on an existing page:
Parent topic: Managing Trees
Editing Tree Attributes
Developers can customize tree behavior by editing tree attributes.
By default, a tree does not have focus and node links are activated with a single click action.
To access the Tree attributes page:
Parent topic: Managing Trees