Index: openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs-postgresql.xql	20 Jul 2001 06:27:31 -0000	1.2
+++ openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs-postgresql.xql	25 Aug 2001 06:14:48 -0000	1.3
@@ -15,5 +15,22 @@
       </querytext>
 </fullquery>
 
+<fullquery name="ec_audit_trail.get_entries_sql">
+      <querytext>
+
+      select $audit_table_name.*,
+           $audit_table_name.oid as rowid,
+           to_char($audit_table_name.last_modified,
+                   'Mon DD, YYYY HH12:MI AM') as last_modified,
+           users.first_names || ' ' || users.last_name
+                   as modifying_user_name
+      from $audit_table_name, cc_users users
+     where users.user_id = $audit_table_name.last_modifying_user $audit_table_id_clause $date_clause
+  order by $audit_table_name.last_modified asc
+
+      </querytext>
+</fullquery>
+
+
  
 </queryset>