Index: openacs-4/packages/assessment/www/session-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/session-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/assessment/www/session-oracle.xql	1 Dec 2008 16:57:02 -0000	1.3
+++ openacs-4/packages/assessment/www/session-oracle.xql	3 Sep 2024 15:37:35 -0000	1.4
@@ -12,19 +12,4 @@
       </querytext>
 </fullquery>
 
-  <fullquery name="get_latest_session">
-    <querytext>
-      select * from (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 in (select revision_id from cr_revisions 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)
-      where rownum=1
-    </querytext>
-  </fullquery>
-
 </queryset>