Forum OpenACS Development: Re: nesting and list-builder

Collapse
12: Re: nesting and list-builder (response to 1)
Posted by Janine Ohmer on 11/17/04 02:45 PM
Oops, just noticed Malte's post.

Considering I just barely grok list builder at this point, I don't think I should be hacking on it.  I might accidentally do something like rewrite the UI to make it actually easy for mere mortals to use. ;)  I do intend to put my work into project manager, provided Jade agrees, and if someone who is more comfortable with list builder internals, and has more time, wants to take it and add it in I'd be happy to answer questions.  But I can't do it myself right now.

Collapse
13: Re: nesting and list-builder (response to 12)
Posted by Andrew Grumet on 11/17/04 05:20 PM
<blockquote>Claudio is correct, you can not maintain the tree
hierarchy and alphabetize in a single query.  Same's true
of CONNECT BY in Oracle.  Just can't be done ...
</blockquote>

Here's a "cheat":  load the three into memory and sort it there.  I think used the tree package (http://web.uvic.ca/~erempel/tcl/tree/tree.html) to do this once.  It wasn't fast, but it worked.

Collapse
14: Re: nesting and list-builder (response to 13)
Posted by Dirk Gomez on 11/17/04 06:26 PM
That's not try anymore for Oracle >= 9i. There is an order by siblings (and some other order by goodies).