| |
64 |
64 |
where class_key = :class_key |
| |
65 |
65 |
</querytext> |
| |
66 |
66 |
</fullquery> |
| |
67 |
67 |
|
| |
68 |
68 |
<fullquery name="ims_enterprise::ims_dotlrn::groups::class.map_class"> |
| |
69 |
69 |
<querytext> |
| |
70 |
70 |
insert into ims_ent_dotlrn_class_map (community_id, class_instance_key) |
| |
71 |
71 |
values (:class_instance_id, :class_instance_key) |
| |
72 |
72 |
</querytext> |
| |
73 |
73 |
</fullquery> |
| |
74 |
74 |
|
| |
75 |
75 |
<fullquery name="ims_enterprise::ims_dotlrn::get_community_id.get_comm_id"> |
| |
76 |
76 |
<querytext> |
| |
77 |
77 |
select community_id from ims_ent_dotlrn_class_map |
| |
78 |
78 |
where class_instance_key = :class_instance_key |
| |
79 |
79 |
</querytext> |
| |
80 |
80 |
</fullquery> |
| |
81 |
81 |
|
| |
82 |
82 |
<fullquery name="ims_enterprise::ims_dotlrn::groups::guess_term.get_best_term"> |
| |
83 |
83 |
<querytext> |
| |
84 |
|
select term_id |
| |
|
84 |
(select term_id |
| |
85 |
85 |
from dotlrn_terms |
| |
86 |
86 |
where start_date >= :start_date |
| |
87 |
87 |
and end_date <= :end_date |
| |
88 |
|
order by end_date DESC |
| |
|
88 |
order by end_date DESC) |
| |
89 |
89 |
UNION |
| |
90 |
|
select term_id |
| |
|
90 |
(select term_id |
| |
91 |
91 |
from dotlrn_terms |
| |
92 |
92 |
where end_date >= now() |
| |
93 |
|
order by end_date DESC |
| |
|
93 |
order by end_date DESC) |
| |
94 |
94 |
limit 1 |
| |
95 |
95 |
</querytext> |
| |
96 |
96 |
</fullquery> |
| |
97 |
97 |
|
| |
98 |
98 |
</queryset> |
