Forum OpenACS Q&A: Re: Content repository with ACS5.0.2

Collapse
Posted by Jade Rubick on
You're working on Oracle, right?

I'm not sure if Oracle needed the tree_sortkey code. What does 'describe acs_objects' say about the acs_objects table?

The CR does have very good support for hierarchical queries. I'm not sure if you'd use tree_sortkey, or use CONNECT BY. I just don't know enough details about how it is implemented.