Index: openacs-4/packages/logger/lib/entries.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/lib/entries.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/logger/lib/entries.xql	4 Jan 2004 21:27:48 -0000	1.1
+++ openacs-4/packages/logger/lib/entries.xql	5 Jan 2004 20:54:25 -0000	1.2
@@ -68,13 +68,13 @@
 
   <fullquery name="select_projections">
     <querytext>
-        select lpe.projection_id as unique_id,
-               lpe.name,
-               to_char(lpe.start_time, 'YYYY-MM-DD') as start_date,
-               to_char(lpe.end_time, 'YYYY-MM-DD') as end_date
-        from logger_projections lpe
-        where lpe.project_id = :selected_project_id
-          and lpe.variable_id = :selected_variable_id
+        select p.projection_id, 
+               p.name,
+               to_char(p.start_time, 'YYYY-MM-DD') as start_date_ansi,
+               to_char(p.end_time, 'YYYY-MM-DD') as end_date_ansi
+        from   logger_projections p
+        where  p.project_id = :project_id
+        order  by p.start_time, p.end_time, lower(p.name)
     </querytext>
   </fullquery>