Index: openacs-4/packages/evaluation/www/admin/tasks/task-add-to-communities.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/task-add-to-communities.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/evaluation/www/admin/tasks/task-add-to-communities.xql	7 Jun 2004 16:05:15 -0000	1.1
+++ openacs-4/packages/evaluation/www/admin/tasks/task-add-to-communities.xql	30 Jul 2004 22:50:11 -0000	1.2
@@ -6,7 +6,9 @@
 <fullquery name="task_grade_info">      
       <querytext>
 
-	select et.task_name, eg.grade_name from evaluation_grades eg, evaluation_tasks et where et.grade_id = eg.grade_id and et.task_id = :task_id
+	select et.task_name, eg.grade_name
+	from evaluation_grades eg, evaluation_tasks et 
+	where et.grade_item_id = eg.grade_item_id and et.task_id = :task_id and content_revision__is_live(eg.grade_id) = true
 	
       </querytext>
 </fullquery>