Index: openacs-4/packages/assessment/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/index-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/assessment/www/index-oracle.xql	4 Oct 2005 12:37:42 -0000	1.5
+++ openacs-4/packages/assessment/www/index-oracle.xql	28 Nov 2006 18:21:23 -0000	1.6
@@ -13,6 +13,7 @@
 where a.assessment_id = cr.revision_id
 and cr.revision_id = ci.latest_revision
 and ci.parent_id = :folder_id
+and ci.publish_status='live'
 and exists (select 1
                    from as_assessment_section_map asm, as_item_section_map ism
                    where asm.assessment_id = a.assessment_id