Oracle APEX Region Plug-In - MT APEX FancyTree

A region plug-in that shows data in a tree format based on a SQL query. It features functionality like drag-and-drop, a right-click menu, checkboxes, grid display and a possibility for master-detail trees. See the demo for some samples of these functionalities.

Install

• Import Plug-In file into your application.

How to use

• Create a region based on the plug-in.
• Add a SQL statement like the one below.

select  empno as value,
        ename as title,
        ename as tooltip,
        'fa fa-user' as icon,
        null as link,
        level as lvl,
        mgr as parent_id
from emp
start with mgr is null
connect by prior empno = mgr
order siblings by ename 

• Set the static ID of the region.
• Create 3 page items.
• Reference the page items in the required attributes of the plug-in.

Demo

https://apex.mt-ag.com/apex/f?p=140

Preview