Skip to Main Content

Overview

Tree is a hierarchical navigational control based on a SQL query executed at runtime.

Instructions

  1. In Page Designer, select a region
  2. Go to the Property Editor
  3. Under the Region tab
    1. Find Identification → Type, use Tree
    2. Find Appearance → Template, use Blank with Attributes

Demo

Sample SQL Query

select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status,
        level,
        task_name as title,
        'icon-tree-folder' as icon,
        id as value,
        task_name as tooltip,
        null  as link 
   from eba_ut_chart_tasks
  start with parent_task is null
connect by prior project = parent_task
  order siblings by task_name