|
|
|
 |
-
/lib/cp-attendance-oracle.xql
(+1 -0)
-
| |
21 |
21 |
et.online_p, |
| |
22 |
22 |
et.late_submit_p, |
| |
23 |
23 |
et.item_id, |
| |
24 |
24 |
et.task_item_id, |
| |
25 |
25 |
et.due_date, |
| |
26 |
26 |
et.requires_grade_p, et.description, et.grade_item_id, |
| |
27 |
27 |
cr.title as task_title, |
| |
28 |
28 |
et.data as task_data, |
| |
29 |
29 |
et.task_id as revision_id, |
| |
30 |
30 |
nvl(round(cr.content_length/1024,0),0) as content_length, |
| |
31 |
31 |
et.late_submit_p, |
| |
32 |
32 |
crmt.label as pretty_mime_type |
| |
33 |
33 |
from cr_revisions cr, |
| |
34 |
34 |
evaluation_tasksi et, |
| |
35 |
35 |
cr_items cri, |
| |
36 |
36 |
cr_mime_types crmt |
| |
37 |
37 |
where cr.revision_id = et.revision_id |
| |
38 |
38 |
and grade_item_id = :grade_item_id |
| |
39 |
39 |
and cri.live_revision = et.task_id |
| |
40 |
40 |
and et.mime_type = crmt.mime_type |
| |
|
41 |
order by due_date asc |
| |
41 |
42 |
</querytext> |
| |
42 |
43 |
</fullquery> |
| |
43 |
44 |
|
| |
44 |
45 |
|
| |
45 |
46 |
</queryset> |
|