Index: openacs-4/packages/assessment/www/asm-admin/export/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/export/index.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/www/asm-admin/export/index.xql 1 Feb 2005 22:05:51 -0000 1.1
+++ openacs-4/packages/assessment/www/asm-admin/export/index.xql 8 Feb 2005 08:45:04 -0000 1.2
@@ -3,18 +3,18 @@
- SELECT s.section_id, s.name as section_name, s.title as section_title, s.description as section_description, s.instructions as section_instructions, s.feedback_text as section_feedback_text, s.max_time_to_complete as section_max_time_to_complete
+ SELECT s.section_id, s.name as section_name, s.title as section_title, s.description as section_description, s.instructions as section_instructions, s.feedback_text as section_feedback_text, s.max_time_to_complete as section_max_time_to_complete, s.num_items as section_num_items, s.points as section_points
FROM as_sectionsx s, as_assessment_section_map asm, as_assessmentsx a
WHERE s.section_id = asm.section_id
AND asm.assessment_id = a.assessment_id
- AND a.assessment_id = :assessment_id
+ AND a.assessment_id = :assessment_id1
ORDER BY s.section_id
- SELECT i.as_item_id, i.title as item_title, i.name as item_name, i.description as item_description, i.subtext as item_subtext, i.field_code as item_field_code, i.required_p as item_required_p, i.data_type as item_data_type, i.max_time_to_complete as item_max_time_to_complete, i.feedback_right as item_feedback_right, i.feedback_wrong as item_feedback_wrong
+ SELECT i.as_item_id, i.title as item_title, i.name as item_name, i.description as item_description, i.subtext as item_subtext, i.field_code as item_field_code, i.required_p as item_required_p, i.data_type as item_data_type, i.max_time_to_complete as item_max_time_to_complete, i.feedback_right as item_feedback_right, i.feedback_wrong as item_feedback_wrong, i.points as item_points
FROM as_itemsx i, as_item_section_map ism
WHERE i.as_item_id = ism.as_item_id AND ism.section_id = :section_id
ORDER BY ism.sort_order
@@ -39,4 +39,60 @@
+
+
+ SELECT asdt.title as section_display_type, asdt.num_items as s_num_items, asdt.adp_chunk as s_adp_chunk, asdt.branched_p as s_branched_p, asdt.back_button_p as s_back_button_p, asdt.submit_answer_p as s_submit_answer_p, asdt.sort_order_type as s_sort_order_type
+ FROM as_section_display_typesx asdt, as_sectionsx s
+ WHERE asdt.display_type_id = s.display_type_id AND s.section_id = :section_id
+
+
+
+
+
+ SELECT html_display_options, choice_orientation, choice_label_orientation, sort_order_type, item_answer_alignment
+ FROM as_item_display_rb
+ WHERE as_item_display_id=:item_display_id
+
+
+
+
+
+ SELECT html_display_options, choice_orientation, choice_label_orientation, sort_order_type, item_answer_alignment
+ FROM as_item_display_cb
+ WHERE as_item_display_id=:item_display_id
+
+
+
+
+
+ SELECT html_display_options, abs_size, item_answer_alignment
+ FROM as_item_display_ta
+ WHERE as_item_display_id=:item_display_id
+
+
+
+
+
+
+ select r.title, i.increasing_p, i.allow_negative_p, i.num_correct_answers,
+ i.num_answers
+ from cr_revisions r, as_item_rels ir, as_item_type_mc i
+ where r.revision_id = i.as_item_type_id
+ and i.as_item_type_id = ir.target_rev_id
+ and ir.item_rev_id = :as_item_id
+ and ir.rel_type = 'as_item_type_rel'
+
+
+
+
+
+
+ SELECT i.as_item_type_id AS id__as_item_type_oq, i.default_value, i.feedback_text
+ from cr_revisions r, as_item_rels ir, as_item_type_oq i
+ where r.revision_id = i.as_item_type_id
+ and i.as_item_type_id = ir.target_rev_id
+ and ir.item_rev_id = :as_item_id
+ and ir.rel_type = 'as_item_type_rel'
+
+