Forum OpenACS Development: Re: groups

Collapse
2: Re: groups (response to 1)
Posted by Dave Bauer on
Try using the group_member_map view.

You'll need to restrict the results where group_id=container_id and rel_type='membership_rel' to avoid duplicates.

It should have the data you need.

Collapse
3: Re: groups (response to 2)
Posted by Iuri Sampaio on
Hi dave,

I create a simple query that does the job

select p.party_name from party_names p, acs_rels r
where r.object_id_two = p.party_id
and r.rel_type = :member_state
and r.object_id_one = $group_id

now i am going to add it into the context in the tcl script and do the proper amends in include permissions on it