antoniop
committed
on 15 Dec 22
Define variables as constants
/admin/imsld-role-members.xql (+6 -3)
5 5                 <querytext>
6 6         select group_name
7 7         from groups
8 8         where group_id=:group_instance
9 9         </querytext>
10 10         </fullquery>
11 11  
12 12     <fullquery name="get_members_list">
13 13                 <querytext>
14 14         select gmm.member_id
15 15         from group_member_map gmm,
16 16              acs_users_all aua
17 17         where  aua.user_id=gmm.member_id
18 18                and gmm.group_id=:group_instance
19 19                 </querytext>
20 20         </fullquery>
21 21
22 22     <fullquery name="get_not_members_list">
23 23                 <querytext>
24 24         select aua.user_id
25           from acs_users_all aua
26           where user_id > 0
27                 and not (user_id in ([join $members_list ","]))
  25         from acs_users_all aua,
  26              dotlrn_member_rels_approved dmra
  27         where aua.user_id > 0
  28               and not (aua.user_id in ([join $members_list ","]))
  29               and aua.user_id=dmra.user_id
  30               and dmra.community_id=:community_id
28 31                 </querytext>
29 32         </fullquery> 
30 33
31 34    
32 35     <fullquery name="get_members_list_2">
33 36                 <querytext>
34 37         select gmm.member_id
35 38         from group_member_map gmm
36 39         where group_id=:group_instance
37 40               and container_id=:group_instance
38 41                 </querytext>
39 42         </fullquery>
40 43
41 44    
42 45     <fullquery name="get_not_members_list_2">
43 46                 <querytext>
44 47         select gmm.member_id
45 48         from group_member_map gmm
46 49         where container_id=:parent_instance
47 50               and not (member_id in ([join $members_list ","]))