| |
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 ","])) |