Hi Don,
In ETP you can arrange the ordering of items on a per folder basis. This is needed for example you want to arrange your links/navigation on a particular way. Most of the time it is not rule based (e.g. alpha, chrono, etc.). You want to arrange it the way it is. The fix that I provited above would be sufficient enough for ETP to work although still broken. Since sorting by using "move up" is broken. Also I think symlinking is broken since it uses tree_sortkey to know the tree_level so it indents the contents in a nice tree like structure in the page.
Here is an example snippet of my cr_items.
select item_id, parent_id, name, tree_sortkey from cr_items order by tree_sortkey;
2673 | 2672 | index | 0000000000000000000000010000001000000000
2699 | 2672 | state_courts | 0000000000000000000000010000001000000001
2708 | 2672 | bankruptcy_court | 0000000000000000000000010000001000000010
3256 | 2672 | court_claims | 0000000000000000000000010000001000000011
3265 | 2672 | court_appeals | 0000000000000000000000010000001000000100
3274 | 2672 | district_court | 0000000000000000000000010000001000000101
3283 | 2672 | supreme_court | 0000000000000000000000010000001000000110
3292 | 2672 | tax_court | 0000000000000000000000010000001000000111
Notice that all items have the same parent_id, so all items resides in a single cr_folder. But since we can use tree_sortkey in PG we can arrange the contents to our preferred arrangement. From what I know this is the default behaviour of CR on PG. So in Oracle there has to be something that ETP can lookup into AND manipulate to order the content items.
I am glad that we are busy with paying jobs although I would really like to have the same rate that you guys are having =).
