Forum .LRN Q&A: How to find out all admins of all dotlrn groups


	The Toolkit for Online Communities 15899 Community Members, 0 members online, 2585 visitors today			Log In	Register

Forum .LRN Q&A: How to find out all admins of all dotlrn groups

OpenACS Home : Forums : .LRN Q&A : How to find out all admins of all dotlrn groups

Back to .LRN Q&A

Icon of Envelope Request notifications

1: How to find out all admins of all dotlrn groups

Posted by Nima Mazloumi on 11/13/06 12:21 PM

Hi,

has someone tried to create a list of all dotlrn administrators before? While classes have 4 different relations subgroups have only two (admin, member). I need to create a mailing list of all administrators.

Greetings,
Nima

2: Re: How to find out all admins of all dotlrn groups (response to 1)

Posted by Dave Bauer on 11/13/06 07:30 PM

Something like this:

select object_id_two from users u, acs_rels a, dotlrn_admin_rels d where a.rel_id=d.rel_id and object_id_two=u.user_id;

You'll want to get unique rows so you only email each admin once.

Back to .LRN Q&A