Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/journal-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/journal-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/journal-postgresql.xql	25 Apr 2001 04:52:44 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/journal-postgresql.xql	19 Nov 2001 18:27:40 -0000	1.2
@@ -1,4 +1,5 @@
 <?xml version="1.0"?>
+
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
@@ -18,14 +19,11 @@
            a.attribute_name as attribute_name, 
 	   a.pretty_name as attribute_pretty_name,
 	   a.datatype as attribute_datatype, 
-	   ai.wf_datatype as attribute_wf_datatype,
 	   v.attr_value as attribute_value
-    from   ((journal_entries j LEFT OUTER JOIN wf_attribute_value_audit v 
-             on v.journal_id = j.journal_id) LEFT OUTER JOIN acs_attributes a 
-               on a.attribute_id = v.attribute_id) LEFT OUTER JOIN 
-           wf_attribute_info ai on ai.attribute_id = v.attribute_id,
-           acs_objects o left outer join parties p 
-            on p.party_id = o.creation_user
+    from   (journal_entries j LEFT OUTER JOIN wf_attribute_value_audit v 
+	     on (j.journal_id = v.journal_id)) LEFT OUTER JOIN acs_attributes a 
+	       on (v.attribute_id = a.attribute_id), 
+	   acs_objects o left outer join parties p on (o.creation_user = p.party_id)
     where  j.object_id = :case_id
       and  o.object_id = j.journal_id
     order  by o.creation_date $sql_order, j.journal_id $sql_order