Index: openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/tasks-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	13 Jan 2005 13:54:36 -0000	1.9
+++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	24 Feb 2005 13:32:57 -0000	1.10
@@ -41,13 +41,16 @@
             LEFT JOIN pm_roles r
             ON ta.role_id = r.role_id,
         cr_items proj,
+	cr_folders f,
         pm_projectsx proj_rev
         WHERE
         ts.task_id  = t.item_id and
         i.item_id   = t.item_id and
         t.task_revision_id = i.live_revision and 
         t.parent_id = proj.item_id and
         proj.live_revision = proj_rev.revision_id
+	and proj.parent_id = f.folder_id
+        and f.package_id = :package_id 
         [template::list::filter_where_clauses -and -name tasks]
         [template::list::orderby_clause -orderby -name tasks]
     </querytext>