select r.one_line, r.role_id, r.is_observer_p, r.is_lead_p, a.party_id from pm_task_assignment a, persons u, pm_roles r where a.task_id = :task_id and u.person_id = a.party_id and a.role_id = r.role_id and exists (select 1 from acs_object_party_privilege_map ppm where ppm.object_id = a.task_id and ppm.privilege = 'read' and ppm.party_id = :user_id) [template::list::orderby_clause -name people -orderby] select r.one_line, r.role_id, r.is_observer_p, r.is_lead_p, a.party_id from pm_task_assignment a, pm_roles r where a.task_id = :task_id and a.role_id = r.role_id and exists (select 1 from acs_object_party_privilege_map ppm where ppm.object_id = a.task_id and ppm.privilege = 'read' and ppm.party_id = :user_id) [template::list::orderby_clause -name people -orderby] select u.first_names || ' ' || u.last_name as assign_name from persons u where u.person_id = :party_id select group_name as assign_name from groups where group_id = :party_id