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.4 -r1.5 --- openacs-4/packages/assessment/www/asm-admin/export/index.xql 14 Feb 2005 12:24:07 -0000 1.4 +++ openacs-4/packages/assessment/www/asm-admin/export/index.xql 15 Feb 2005 18:07:50 -0000 1.5 @@ -121,4 +121,16 @@ and ir.rel_type = 'as_item_type_rel' + + + + SELECT count(aic.correct_answer_p) as num_answers_correct + FROM cr_revisions r, as_item_choicesx aic + left outer join cr_revisions r2 on (r2.revision_id = aic.content_value) + left outer join cr_items i on (i.item_id = r2.item_id) + WHERE aic.mc_id= :mc_id + and r.revision_id = aic.choice_id + and aic.correct_answer_p = 't' + +