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