Oracle APEX - Popup LOV Tree View Plugin

When users are filling out forms and application data, and they need to pick from a list of values (LOV), some data types are naturally hierarchical, meaning they are organized in levels (e.g., parent-child-grandchild). Examples are Geographic Locations, Product Items organized to Product Categories, Workflow Participants organized to Groups or Roles, Religions categorized into Groups, etc.

To support hierarchical data navigation in Popup LOV’s with collapsible items, sharing a plugin by which you can apply a Tree View to the LOV. It will be based on an hierarchical query. The below example enables the user to select a product from a tree view where products are organized to product (sub)categories:

It has provisions for disabling the selecting of parent nodes (the categories), the initial state of the Tree View (collapsed/expanded), the initial expand level in case of opening expanded, an Expand/Collapse All button in top, and tooltips on the LOV items. See github for the details.

For this plugin, I took as starting point the 'APEX Interactive Grid Treegrid Enhancement APEX Dynamic Action Plugin' by Báldogi Richárd, which in turn is based on the 'TreeGrid jQuery plugin' by Maksym Pomazan.

An example page you find here.

And that makes up plugin #10 under the lib4x embrella. Stay tuned for more :-)