Index: openacs-4/packages/evaluation-portlet/lib/evaluations-chunk.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/lib/evaluations-chunk.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/evaluation-portlet/lib/evaluations-chunk.xql	4 Apr 2005 18:23:47 -0000	1.3
+++ openacs-4/packages/evaluation-portlet/lib/evaluations-chunk.xql	31 May 2005 23:13:21 -0000	1.3.2.1
@@ -1,42 +1,14 @@
 <?xml version="1.0"?>
 
 <queryset>
+   <rdbms><type>postgresql</type><version>7.3</version></rdbms>
 
 <fullquery name="get_grade_info">      
       <querytext>
-	select grade_plural_name, weight as grade_weight from evaluation_grades where grade_id = :grade_id
-      </querytext>
-</fullquery>
 
-<fullquery name="get_tasks_admin">      
-      <querytext>
-	select et.task_name, 
-	round(et.weight,2) as task_weight,
-    et.task_id
-	from evaluation_tasksi et, cr_items cri
-	where grade_item_id = :grade_item_id
-	  and cri.live_revision = et.task_id
-      $evaluations_orderby
+		select upper(grade_plural_name) as grade_plural_name, grade_plural_name as low_name,grade_name,weight as grade_weight,weight as category_weight from evaluation_grades where grade_id = :grade_id
+	
       </querytext>
 </fullquery>
 
-<fullquery name="get_grade_tasks">      
-      <querytext>
-	select et.task_name, 
-	et.task_item_id,
-	et.weight as t_weight,
-	eg.weight as g_weight,
-	round((et.weight*eg.weight)/100,2) as task_weight,
-	et.number_of_members,
-        et.task_id
-	from evaluation_grades eg,
-	evaluation_tasksi et,
-	cr_items cri
-	where eg.grade_id = :grade_id
-	and eg.grade_item_id = et.grade_item_id
-	and cri.live_revision = et.task_id
-	$evaluations_orderby
-      </querytext>
-</fullquery>
-
 </queryset>