Index: openacs-4/packages/assessment/www/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/index.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/assessment/www/index.xql 29 Dec 2004 10:19:07 -0000 1.5 +++ openacs-4/packages/assessment/www/index.xql 7 Jan 2005 16:10:44 -0000 1.6 @@ -1,15 +1,18 @@ - - - select cr.item_id as assessment_id, cr.title, cr.description - from as_assessments a, cr_revisions cr, cr_items ci - where a.assessment_id = cr.revision_id - and cr.revision_id = ci.latest_revision - and exists (select 1 from as_assessment_section_map asm - where asm.assessment_id = a.assessment_id) - - + + + select cr.item_id as assessment_id, cr.title, cr.description + from as_assessments a, cr_revisions cr, cr_items ci + where a.assessment_id = cr.revision_id + and cr.revision_id = ci.latest_revision + and ci.parent_id = :folder_id + and exists (select 1 + from as_assessment_section_map asm, as_item_section_map ism + where asm.assessment_id = a.assessment_id + and ism.section_id = asm.section_id) + +