Index: openacs-4/packages/assessment/www/asm-admin/action-params.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/action-params.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/assessment/www/asm-admin/action-params.xql 18 Feb 2005 16:18:49 -0000 1.4
+++ openacs-4/packages/assessment/www/asm-admin/action-params.xql 12 Jun 2006 02:49:51 -0000 1.5
@@ -30,23 +30,15 @@
- select cri.title, sm.as_item_id
+ select cri.title, cri.item_id as as_item_id
from as_item_section_map sm, cr_revisions cri
- where sm.as_item_id = cri.revision_id and sm.section_id in (
- select s.section_id
- from as_sections s, cr_revisions cr, cr_items ci,
- as_assessment_section_map asm,as_item_section_map sm
- where ci.item_id = cr.item_id
- and cr.revision_id = s.section_id
- and s.section_id = asm.section_id
- and asm.assessment_id = :new_assessment_revision)
-
+ where sm.as_item_id = cri.revision_id and sm.section_id = :section_id
- select cri.title, sm.as_item_id
+ select cri.title, cri.item_id as as_item_id
from as_item_section_map sm, cr_revisions cri
where sm.as_item_id = cri.revision_id and sm.section_id in (
select s.section_id