| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
<queryset> |
| |
3 |
3 |
<rdbms><type>oracle</type><version>8.1.6</version></rdbms> |
| |
4 |
4 |
|
| |
5 |
5 |
<fullquery name="session_data"> |
| |
6 |
6 |
<querytext> |
| |
7 |
7 |
SELECT percent_score, to_char(creation_datetime, :format) AS session_start, |
| |
8 |
8 |
to_char(completed_datetime, :format) AS session_finish, |
| |
9 |
9 |
round(86400 * (completed_datetime-creation_datetime)) AS session_time |
| |
10 |
10 |
FROM as_sessions s |
| |
11 |
11 |
WHERE s.session_id = :session_id |
| |
12 |
12 |
</querytext> |
| |
13 |
13 |
</fullquery> |
| |
14 |
14 |
|
| |
15 |
|
<fullquery name="get_latest_session"> |
| |
16 |
|
<querytext> |
| |
17 |
|
select * from (select max(o.creation_date), s.session_id |
| |
18 |
|
from as_sessions s, |
| |
19 |
|
acs_objects o, |
| |
20 |
|
cr_revisions cr |
| |
21 |
|
where s.subject_id=:user_id |
| |
22 |
|
and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id) |
| |
23 |
|
and o.object_id = cr.item_id |
| |
24 |
|
and s.session_id = cr.revision_id |
| |
25 |
|
group by assessment_id, subject_id, session_id) |
| |
26 |
|
where rownum=1 |
| |
27 |
|
</querytext> |
| |
28 |
|
</fullquery> |
| |
29 |
|
|
| |
30 |
15 |
</queryset> |
