Index: openacs-4/packages/cms/www/modules/templates/template-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/templates/template-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cms/www/modules/templates/template-oracle.xql	25 May 2001 23:49:05 -0000	1.1
+++ openacs-4/packages/cms/www/modules/templates/template-oracle.xql	19 Aug 2002 04:19:45 -0000	1.2
@@ -35,5 +35,29 @@
       </querytext>
 </fullquery>
 
- 
+<fullquery name="get_items">      
+      <querytext>
+
+select
+      t.tree_level, t.context_id, content_item.get_title(t.context_id) as title
+    from (
+      select 
+        context_id, level as tree_level
+      from 
+        acs_objects
+      where
+        context_id <> 0
+      connect by
+        prior context_id = object_id
+      start with
+        object_id = :template_id
+      ) t, cr_items i
+    where
+      i.item_id = t.context_id
+    order by
+      tree_level desc
+
+       </querytext>
+</fullquery>
+
 </queryset>