Index: openacs-4/packages/evaluation-portlet/www/evaluation-assignments-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/www/evaluation-assignments-portlet-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/evaluation-portlet/www/evaluation-assignments-portlet-postgresql.xql	30 Jul 2004 22:51:50 -0000	1.2
+++ openacs-4/packages/evaluation-portlet/www/evaluation-assignments-portlet-postgresql.xql	30 Aug 2004 08:41:52 -0000	1.3
@@ -10,8 +10,9 @@
 		eg.grade_id,
 		eg.grade_item_id
    	 	from evaluation_gradesx eg, acs_objects ao
-		where content_revision__is_live(eg.grade_id) = true
-          and eg.item_id = ao.object_id
+		where (select count(*) from cr_items
+	            where live_revision = eg.grade_id) > 0
+	          and eg.item_id = ao.object_id	
    		  and ao.context_id in  ([join $list_of_package_ids ,])
 		order by grade_plural_name desc
 	
Index: openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql	30 Jul 2004 22:51:50 -0000	1.4
+++ openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql	30 Aug 2004 08:41:53 -0000	1.5
@@ -10,8 +10,9 @@
 		eg.grade_id,
 		eg.grade_item_id
    	 	from evaluation_gradesx eg, acs_objects ao
-		where content_revision__is_live(eg.grade_id) = true
-          and eg.item_id = ao.object_id
+		where (select count(*) from cr_items
+	            where live_revision = eg.grade_id) > 0
+        	  and eg.item_id = ao.object_id
    		  and ao.context_id in  ([join $list_of_package_ids ,])
 		order by grade_plural_name desc