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.8 -r1.9
--- openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql	11 Sep 2004 00:41:10 -0000	1.8
+++ openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql	7 Apr 2005 11:26:30 -0000	1.9
@@ -3,22 +3,6 @@
 <queryset>
 <rdbms><type>postgresql</type><version>7.3</version></rdbms>
 
-<fullquery name="get_grades">      
-      <querytext>
-
-	select eg.grade_plural_name,
-	eg.grade_id,
-	eg.grade_item_id
-	from evaluation_grades eg, acs_objects ao
-	where exists (select 1 from cr_items
-           where live_revision = eg.grade_id) 
-	  and eg.grade_item_id = ao.object_id
-	  and ao.context_id in  ([join $list_of_package_ids ,])
-	order by grade_plural_name desc
-	
-      </querytext>
-</fullquery>
-
 <fullquery name="get_total_grade">      
       <querytext>
 
@@ -55,23 +39,4 @@
       </querytext>
 </fullquery>
 
-<fullquery name="max_possible_grade">      
-      <querytext>
-
-    select sum(round(et.weight*eg.weight/100,2))
-    from evaluation_tasks et,
-    evaluation_grades eg,
-    cr_items cri1,
-    cr_items cri2,
-    acs_objects ao
-    where et.grade_item_id = eg.grade_item_id
-    and cri1.live_revision = eg.grade_id
-    and cri2.live_revision = et.task_id
-    and et.requires_grade_p = 't'
-    and ao.object_id = eg.grade_item_id
-    and ao.context_id = :package_id
-
-      </querytext>
-</fullquery>
-
 </queryset>