Index: openacs-4/packages/assessment/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/index-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/assessment/www/index-postgresql.xql	22 Apr 2005 15:16:52 -0000	1.5
+++ openacs-4/packages/assessment/www/index-postgresql.xql	28 Nov 2006 18:21:23 -0000	1.6
@@ -12,6 +12,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