Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v
diff -u -N -r1.13 -r1.14
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	1 Jul 2004 22:56:19 -0000	1.13
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	24 Feb 2005 13:32:57 -0000	1.14
@@ -46,10 +46,13 @@
                         ctg.deprecated_p = 'f')
                  c ON p.item_id = c.object_id, 
         cr_items i, 
+	cr_folders f,
         pm_project_status s
         WHERE 
         p.project_id = i.live_revision and
         s.status_id           = p.status_id
+	and i.parent_id = f.folder_id
+        and f.package_id = :package_id 
         [template::list::filter_where_clauses -and -name projects]
         [template::list::orderby_clause -orderby -name projects]
     </querytext>