Index: openacs-4/packages/imsld/www/admin/imsld-role-members.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/admin/imsld-role-members.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/imsld/www/admin/imsld-role-members.xql	30 Mar 2006 16:32:28 -0000	1.2
+++ openacs-4/packages/imsld/www/admin/imsld-role-members.xql	24 Apr 2006 09:40:20 -0000	1.3
@@ -22,9 +22,12 @@
     <fullquery name="get_not_members_list">
 		<querytext>
         select aua.user_id
-        from acs_users_all aua
-        where user_id > 0
-              and not (user_id in ([join $members_list ","]))
+        from acs_users_all aua,
+             dotlrn_member_rels_approved dmra
+        where aua.user_id > 0
+              and not (aua.user_id in ([join $members_list ","]))
+              and aua.user_id=dmra.user_id
+              and dmra.community_id=:community_id
 		</querytext>
 	</fullquery>