Index: openacs-4/packages/logger/lib/entries-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/lib/entries-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/logger/lib/entries-oracle.xql	4 Jan 2004 21:27:48 -0000	1.1
+++ openacs-4/packages/logger/lib/entries-oracle.xql	3 Jun 2004 21:08:23 -0000	1.2
@@ -29,4 +29,32 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="select_entries2">
+    <querytext>
+    select le.entry_id,
+           le.time_stamp,
+           to_char(le.time_stamp, 'YYYY-MM-DD HH24:MI:SS') as time_stamp_ansi,
+           to_char(le.time_stamp, 'IW-YYYY') as time_stamp_week,
+           le.value,
+           le.description,
+           lp.project_id,               
+           lp.name as project_name,
+           submitter.person_id as user_id,
+           submitter.first_names || ' ' || submitter.last_name as user_name,
+           c.category_id,
+           c.tree_id
+    from   logger_entries le 
+           LEFT OUTER JOIN 
+           category_object_map_tree c on (c.object_id = le.entry_id),
+           logger_projects lp,
+           acs_objects ao,
+           persons submitter
+    where  le.project_id = lp.project_id
+    and    ao.object_id = le.entry_id 
+    and    ao.creation_user = submitter.person_id
+    [list::filter_where_clauses -and -name "entries"]
+    [list::orderby_clause -orderby -name "entries"]
+    </querytext>
+  </fullquery>
+
 </queryset>