Index: openacs-4/packages/evaluation/www/admin/evaluations/student-list-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/student-list-postgresql.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/evaluation/www/admin/evaluations/student-list-postgresql.xql	12 Aug 2004 17:46:42 -0000	1.8
+++ openacs-4/packages/evaluation/www/admin/evaluations/student-list-postgresql.xql	24 Aug 2004 22:40:32 -0000	1.9
@@ -106,4 +106,36 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_task_info">      
+      <querytext>
+
+	select et.task_name,
+		et.task_item_id,
+		eg.grade_id,
+		eg.grade_plural_name,
+		eg.weight as grade_weight,
+		et.weight as task_weight,
+		to_char(et.due_date, 'YYYY-MM-DD HH24:MI:SS') as due_date_ansi,
+		et.number_of_members,
+		et.online_p
+		from evaluation_grades eg, evaluation_tasks et
+		where et.task_id = :task_id
+		  and et.grade_item_id = eg.grade_item_id
+		  and content_revision__is_live(eg.grade_id) = true
+	
+      </querytext>
+</fullquery>
+
+<partialquery name="sql_query_groups">
+	  <querytext>         
+		select acs_group__name(etg.group_id) as party_name,
+		etg.group_id as party_id
+		from evaluation_task_groups etg, evaluation_tasks et
+        where etg.task_item_id = et.task_item_id
+		and et.task_id = :task_id
+		$not_in_clause
+		$orderby_na
+	  </querytext>
+</partialquery>
+
 </queryset>