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.5.2.12 -r1.5.2.13 --- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 30 Apr 2005 06:53:09 -0000 1.5.2.12 +++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 4 May 2005 06:13:53 -0000 1.5.2.13 @@ -53,8 +53,12 @@ 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 + and f.package_id = :package_id [template::list::page_where_clause -and -name "tasks" -key "ts.task_id"] + and exists (select 1 from acs_object_party_privilege_map ppm + where ppm.object_id = ts.task_id + and ppm.privilege = 'read' + and ppm.party_id = :user_id) [template::list::filter_where_clauses -and -name tasks] [template::list::orderby_clause -orderby -name tasks]