Index: openacs-4/packages/assessment-portlet/www/assessment-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment-portlet/www/assessment-portlet-oracle.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/assessment-portlet/www/assessment-portlet-oracle.xql	20 Sep 2006 15:04:15 -0000	1.4
+++ openacs-4/packages/assessment-portlet/www/assessment-portlet-oracle.xql	15 May 2007 20:14:19 -0000	1.5
@@ -17,6 +17,7 @@
 	where a.assessment_id = cr.revision_id
 	and cr.revision_id = ci.latest_revision
 	and ci.parent_id = cf.folder_id
+        and ci.publish_status='live'
 	and cf.package_id in ([join $list_of_package_ids ", "])
 	and sa.object_id = cf.package_id
 	and sc.node_id = sa.parent_id