Index: openacs-4/packages/assessment/lib/session-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/lib/session-postgresql.xql	12 Jun 2006 03:30:09 -0000	1.1
+++ openacs-4/packages/assessment/lib/session-postgresql.xql	26 Sep 2006 04:08:36 -0000	1.2
@@ -12,4 +12,19 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_latest_session">
+     <querytext>
+	select max(o.creation_date), s.session_id 
+        from as_sessions s, 
+        acs_objects o,
+        cr_revisions cr
+	where s.subject_id=:user_id
+	and s.assessment_id=(select latest_revision from cr_items where item_id=:assessment_id)
+	and o.object_id = cr.item_id
+        and s.session_id = cr.revision_id
+	group by assessment_id, subject_id, session_id
+	limit 1
+    </querytext>
+</fullquery>
+
 </queryset>