Home
The Toolkit for Online Communities
17327 Community Members, 1 member online, 2135 visitors today
Log In Register
OpenACS Home : Forums : .LRN Q&A : How to find out all admins of all dotlrn groups : One Message

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

Collapse
Posted by Dave Bauer on
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.