Index: openacs-4/packages/xowiki/tcl/folder-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/xowiki/tcl/folder-procs.tcl,v
diff -u -r1.27.2.14 -r1.27.2.15
--- openacs-4/packages/xowiki/tcl/folder-procs.tcl	8 May 2015 18:57:05 -0000	1.27.2.14
+++ openacs-4/packages/xowiki/tcl/folder-procs.tcl	12 Aug 2015 08:25:57 -0000	1.27.2.15
@@ -79,14 +79,37 @@
     # Oracle query missing
     #
     return [subst {
-      With RECURSIVE child_items AS (
-        select * from xowiki_form_instance_item_index where item_id = '$parent_id'
-      UNION ALL
-        select xi.* from xowiki_form_instance_item_index xi, child_items
-        where xi.parent_id = child_items.item_id
-      )
-      select * from child_items
-      where page_template = '$form_id' and package_id = '$package_id' and publish_status = 'ready'
+    select
+         xi.package_id, xi.parent_id, xi.name,
+         xi.publish_status, xi.assignee, xi.state, xi.page_template, xi.item_id,
+         o.object_id, o.object_type, o.title AS object_title, o.context_id,
+         o.security_inherit_p, o.creation_user, o.creation_date, o.creation_ip,
+         o.last_modified, o.modifying_user, o.modifying_ip,
+         --o.tree_sortkey, o.max_child_sortkey,
+         cr.revision_id, cr.title, content_revision__get_content(cr.revision_id) AS text,
+         cr.description, cr.publish_date, cr.mime_type, cr.nls_language,
+         xowiki_form_page.xowiki_form_page_id,
+         xowiki_page_instance.page_instance_id,
+         xowiki_page_instance.instance_attributes,
+         xowiki_page.page_id,
+         xowiki_page.page_order,
+         xowiki_page.creator
+      from (
+         WITH RECURSIVE child_items AS (
+           select * from xowiki_form_instance_item_index
+           where item_id = '$parent_id'
+         UNION ALL
+           select xi.* from xowiki_form_instance_item_index xi, child_items
+           where xi.parent_id = child_items.item_id
+         )
+         select * from child_items
+         where page_template = '$form_id' and package_id = '$package_id' and publish_status = 'ready') xi
+         left join cr_items ci on (ci.item_id = xi.item_id)
+         left join cr_revisions cr on (cr.revision_id = ci.live_revision)
+         left join acs_objects o on (o.object_id = ci.live_revision)
+         left join xowiki_page on (o.object_id = xowiki_page.page_id)
+         left join xowiki_page_instance on (o.object_id = xowiki_page_instance.page_instance_id)
+         left join xowiki_form_page on (o.object_id = xowiki_form_page.xowiki_form_page_id)      
     }]
   }