Tree Queries
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Tree Queries
| Line 71: | Line 71: | ||
"level" is the depth in the tree (counts from one, so we took one off), and multiplied by 4 so that the indentations are visible, and used lpad to add that many spaces to the beginning of the granted_role. | "level" is the depth in the tree (counts from one, so we took one off), and multiplied by 4 so that the indentations are visible, and used lpad to add that many spaces to the beginning of the granted_role. | ||
| + | |||
| + | See also: | ||
| + | |||
| + | [[Direct Reports]] - this uses the recursive SQL method for displaying a tree. | ||
