Index: openacs-4/packages/workflow/www/admin/workflow-ae-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/www/admin/workflow-ae-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/workflow/www/admin/workflow-ae-postgresql.xql	4 Jan 2007 09:04:10 -0000	1.2
+++ openacs-4/packages/workflow/www/admin/workflow-ae-postgresql.xql	22 Oct 2018 09:51:26 -0000	1.3
@@ -1,7 +1,14 @@
 <?xml version="1.0"?>
  <queryset>
    <rdbms><type>postgresql</type><version>7.2</version></rdbms>
+   
          <fullquery name="get_packages">
+ 	         <querytext>
+ 	           select object_id,name, name as rawname, 1 as level from site_nodes s where s.parent_id is null;
+ 	         </querytext>
+         </fullquery>   
+
+         <fullquery name="get_packages_old">
                  <querytext>
  	                 select  n.name,
  	                         n.object_id,
@@ -10,7 +17,7 @@
  	                 from    site_nodes n, site_nodes n2
  	                 where   n.name is not null
  	                 and     n.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey)
- 	                 and     n.object_id=405
+ 	                 and     n.object_id in (select s.object_id from site_nodes s where s.parent_id is null)
                  </querytext>
          </fullquery>
  </queryset>