Index: openacs-4/packages/evaluation/lib/audit-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/audit-chunk-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/evaluation/lib/audit-chunk-postgresql.xql	10 Jun 2004 21:08:52 -0000	1.2
+++ openacs-4/packages/evaluation/lib/audit-chunk-postgresql.xql	7 Jul 2004 17:26:44 -0000	1.3
@@ -1,17 +1,19 @@
 <?xml version="1.0"?>
 
 <queryset>
-   <rdbms><type>postgresql</type><version>7.4</version></rdbms>
+   <rdbms><type>postgresql</type><version>7.3</version></rdbms>
 
 <fullquery name="get_task_audit_info">      
       <querytext>
 
 	select to_char(ese.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
-	ese.modifying_user,
+	coalesce(person__name(ese.modifying_user),person__name(ese.creation_user)) as modifying_user,
 	ese.modifying_ip,
 	ese.description as comments,
 	ese.grade as task_grade,
-	content_revision__is_live(evaluation_id) as is_live
+	case when content_revision__is_live(evaluation_id) = true then 1
+	  else 0 
+      	end as is_live
 	from evaluation_student_evalsx ese
 	where ese.task_id = :task_id
       and ese.party_id = :party_id