select r.rel_id,
u.first_names || ' ' || u.last_name as name
from acs_rels r,
membership_rels mr,
cc_users u
where r.object_id_one = :group_id
and mr.rel_id = r.rel_id
and u.user_id = r.object_id_two
[template::list::filter_where_clauses -and -name "members"]
[template::list::orderby_clause -orderby -name "members"]
select r.rel_id,
u.user_id,
u.first_names || ' ' || u.last_name as name,
u.email,
r.rel_type,
rt.role_two as rel_role,
role.pretty_name as rel_role_pretty,
mr.member_state
from acs_rels r,
membership_rels mr,
cc_users u,
acs_rel_types rt,
acs_rel_roles role
where r.object_id_one = :group_id
and mr.rel_id = r.rel_id
and u.rel_id = mr.rel_id
and u.user_id = r.object_id_two
and rt.rel_type = r.rel_type
and role.role = rt.role_two
[template::list::filter_where_clauses -and -name "members"]
[template::list::page_where_clause -and -name "members" -key "r.rel_id"]
[template::list::orderby_clause -orderby -name "members"]