Index: openacs-4/packages/assessment/lib/results-messages.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/results-messages.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/assessment/lib/results-messages.xql	26 Sep 2006 00:22:44 -0000	1.3
+++ openacs-4/packages/assessment/lib/results-messages.xql	15 May 2007 20:14:16 -0000	1.4
@@ -5,20 +5,19 @@
 <querytext>
 
     select cr.title, cr.description, sr.points, p.first_names, p.last_name,
-           o.creation_date, o.creation_user
+           o.creation_date, o.creation_user, d.session_id
     from as_session_results sr, cr_revisions cr, acs_objects o, persons p,
          as_item_data d, as_session_item_map m
     where cr.revision_id = sr.result_id
     and o.object_id = cr.revision_id
     and cr.description is not null
     and p.person_id = o.creation_user
     and sr.target_id = d.item_data_id
-    and d.session_id = :session_id
     and d.section_id = :section_id
     and d.as_item_id = :as_item_id
     and m.item_data_id = d.item_data_id
     and m.session_id = d.session_id
-    order by o.creation_date
+    order by d.session_id desc, o.creation_date desc
 
 </querytext>
 </fullquery>