How to Make a Recursive Tree View
To make a recursive tree view:
All the child nodes of that tree view node will select the same kind of data. A single SQL query is used to display data a number of levels deep.
For example, for Tree View Node 1, set Child Nodes property to: Tree View Node 1.
WHERE :"treeLevel" < 4
A tree view displays all sub-departments per department. The SQL Query of Tree View Node 1, the root node, is:
WHERE super_department_name = :DEPT_NAME
The Child Nodes property of Tree View Node 1 is Tree View Node 1.
The :DEPTNAME embedded method call refers to the dep_name column values one level higher in the recursive tree.