Index: openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/Attic/evaluations-chunk-oracle.xql,v
diff -u -N -r1.2.2.1 -r1.2.2.2
--- openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql	4 Oct 2005 17:45:42 -0000	1.2.2.1
+++ openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql	8 Apr 2006 21:05:27 -0000	1.2.2.2
@@ -6,7 +6,7 @@
 
 <fullquery name="get_group_id">      
       <querytext>
-	select evaluation.party_id(:user_id,:task_id)
+	select evaluation.party_id(:user_id,:task_id) from dual
       </querytext>
 </fullquery>
 
@@ -26,14 +26,29 @@
 
 <fullquery name="get_answer_info">      
       <querytext>
-	    select crr.filename as answer_data, 
-	    crr.title as answer_title, 
-	    ea.answer_id 
-	    from evaluation_answers ea, cr_items cri, cr_revisions crr
+	    select ea.data as answer_data, 
+	    ea.title as answer_title, 
+	    ea.answer_id,to_char(ea.creation_date,'MM/DD/YYYY HH24:MI') as creation_date
+	    from evaluation_answersi ea, cr_items cri
 	    where ea.task_item_id = :task_item_id 
 	    and cri.live_revision = ea.answer_id
-		and crr.revision_id = ea.answer_id 
-	    and ea.party_id = evaluation.party_id(:user_id,:task_id)
+	    and ea.party_id = 
+	( select 
+	CASE  
+	  WHEN et3.number_of_members = 1 THEN 
+	(select user_id from users where user_id = :user_id)
+	  ELSE  
+	(select etg2.group_id from evaluation_task_groups etg2, 
+                               evaluation_tasks et2, 
+                               acs_rels map 
+                          where map.object_id_one = etg2.group_id 
+                            and map.object_id_two = :user_id 
+                            and etg2.task_item_id = et2.task_item_id 
+                            and et2.task_id = :task_id) 
+	END as nom 
+      from evaluation_tasks et3 
+      where et3.task_id = :task_id 
+	) 
       </querytext>
 </fullquery>