Using groups and parties in OpenACS

To find out all the email addresses of people in an OpenACS group:

select p.email 
from group_member_map m, parties p 
where m.member_id = p.party_id and 
group_id = 
   (select group_id from groups where group_name = 'MyGroupName');

To add a group (untested):

You have to add the group, but also add a relationship between the group and the ''application group''.

Something like:

set your_group_id [group::add (lots of options here)]
set application_group_id [application_group::group_id_from_package_id [ad_conn subsite_id]]
relation_add composition_rel $application_group_id $your_group_id

Thanks, Dave!