Index: openacs-4/packages/project-manager/lib/assignee-portlet.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/lib/assignee-portlet.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/project-manager/lib/assignee-portlet.xql 15 Sep 2005 07:43:14 -0000 1.4 +++ openacs-4/packages/project-manager/lib/assignee-portlet.xql 15 Sep 2005 22:40:21 -0000 1.5 @@ -8,31 +8,6 @@ - - - SELECT - a.project_id, - r.one_line as role_name, - p.first_names || ' ' || p.last_name as user_name, - a.party_id, - r.is_lead_p - FROM - pm_project_assignment a, - pm_roles r, - persons p - WHERE - a.role_id = r.role_id and - a.party_id = p.person_id and - project_id = :project_item_id - and exists (select 1 from acs_object_party_privilege_map ppm - where ppm.object_id = :project_item_id - and ppm.privilege = 'read' - and ppm.party_id = :user_id) - ORDER BY - r.role_id, p.first_names, p.last_name - - - SELECT