| |
19 |
19 |
and s.session_id = :session_id |
| |
20 |
20 |
and s.section_id = :section_id |
| |
21 |
21 |
and i.as_item_id = s.as_item_id |
| |
22 |
22 |
and r.revision_id = i.as_item_id |
| |
23 |
23 |
and ci.item_id = r.item_id |
| |
24 |
24 |
and m.as_item_id = s.as_item_id |
| |
25 |
25 |
and m.section_id = s.section_id |
| |
26 |
26 |
and ir.item_rev_id = s.as_item_id |
| |
27 |
27 |
and ir.rel_type = 'as_item_type_rel' |
| |
28 |
28 |
order by s.sort_order |
| |
29 |
29 |
|
| |
30 |
30 |
</querytext> |
| |
31 |
31 |
</fullquery> |
| |
32 |
32 |
|
| |
33 |
33 |
<fullquery name="as::section::items.section_items"> |
| |
34 |
34 |
<querytext> |
| |
35 |
35 |
|
| |
36 |
36 |
select i.as_item_id, ci.name, cr.title, cr.description, i.subtext, |
| |
37 |
37 |
m.required_p, m.max_time_to_complete, r2.revision_id as content_rev_id, |
| |
38 |
38 |
r2.title as content_filename, ci2.content_type, m.fixed_position, |
| |
39 |
|
ir.target_rev_id as as_item_type_id |
| |
|
39 |
ir.target_rev_id as as_item_type_id, i.validate_block |
| |
40 |
40 |
from as_item_section_map m, as_items i, cr_revisions cr, cr_items ci, |
| |
41 |
41 |
as_item_rels ar, cr_revisions r2, cr_items ci2, as_item_rels ir |
| |
42 |
42 |
where ar.item_rev_id (+) = i.as_item_id |
| |
43 |
43 |
and ar.rel_type (+) = 'as_item_content_rel' |
| |
44 |
44 |
and ar.target_rev_id = r2.revision_id (+) |
| |
45 |
45 |
and ci2.item_id (+) = r2.item_id |
| |
46 |
46 |
and cr.revision_id = i.as_item_id |
| |
47 |
47 |
and i.as_item_id = m.as_item_id |
| |
48 |
48 |
and m.section_id = :section_id |
| |
49 |
49 |
and ci.item_id = cr.item_id |
| |
50 |
50 |
and ir.item_rev_id = i.as_item_id |
| |
51 |
51 |
and ir.rel_type = 'as_item_type_rel' |
| |
52 |
52 |
order by m.sort_order |
| |
53 |
53 |
|
| |
54 |
54 |
</querytext> |
| |
55 |
55 |
</fullquery> |
| |
56 |
56 |
|
| |
57 |
57 |
<fullquery name="as::section::calculate.max_section_points"> |
| |
58 |
58 |
<querytext> |
| |
59 |
59 |
|
