Forum OpenACS Q&A: Extracting all 'node_id' in one branche

Collapse
1: Extracting all 'node_id' in one branche
Posted by xx xx on 02/20/03 12:56 AM
I'm looking for code that will return all node_id’s from the site_nodes table that belong to one branche. For example all node_id’s that belong to a certain class or community (subdirectories in the site-map).

I suppose I should use tree_sortkey, but I didn’t find existing procs, so I could use some advice here.

Collapse
2: Re: Extracting all 'node_id' in one branche (response to 1)
Posted by Dan Wickstrom on 02/20/03 01:58 AM
Try something like the following: 

select n1.* from site_nodes n1,
       (select tree_sortkey from site_nodes where node_id = :branch_root_node) n2 
where n1.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey);