Index: openacs-4/packages/cms/www/modules/items/children-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/children-oracle.xql,v
diff -u -N -r1.1 -r1.1.4.1
--- openacs-4/packages/cms/www/modules/items/children-oracle.xql	8 Jun 2001 01:44:53 -0000	1.1
+++ openacs-4/packages/cms/www/modules/items/children-oracle.xql	27 Feb 2003 13:17:27 -0000	1.1.4.1
@@ -7,7 +7,7 @@
       <querytext>
 
   select
-    t.pretty_name, c.child_type
+    distinct t.pretty_name, c.child_type
   from
     acs_object_types t, cr_type_children c
   where
@@ -18,5 +18,32 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_children">
+      <querytext>
+select  
+     r.rel_id,  
+     r.child_id item_id,  
+     t.pretty_name as type_name,  
+     NVL(r.relation_tag, '-') as tag,  
+     trim(NVL(content_item.get_title(r.child_id), i.name)) title,  
+     ot.pretty_name as content_type  
+   from  
+     cr_child_rels r, acs_objects o, acs_object_types t,  
+     cr_items i, acs_object_types ot  
+   where  
+     r.parent_id = :item_id  
+   and  
+     o.object_id = r.rel_id  
+   and  
+     t.object_type = o.object_type  
+   and  
+     i.item_id = r.child_id  
+   and  
+     ot.object_type = i.content_type  
+   order by  
+     order_n, title
+
+      </querytext>
+</fullquery>
  
 </queryset>