Index: openacs-4/packages/assessment/www/asm-admin/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/index-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/www/asm-admin/index-oracle.xql	1 Feb 2005 22:00:10 -0000	1.1
+++ openacs-4/packages/assessment/www/asm-admin/index-oracle.xql	7 Aug 2017 23:48:04 -0000	1.2
@@ -16,4 +16,18 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_all_assessments">
+  <querytext>
+    
+    select ci.item_id as assessment_id, cr.title, ci.publish_status
+     from cr_items ci, cr_revisions cr
+    where cr.revision_id = ci.latest_revision
+      and ci.content_type = 'as_assessments'
+      and ci.parent_id = :folder_id
+      and acs_permission.permission_p(ci.item_id, :user_id, 'admin')
+    order by cr.title
+    
+  </querytext>
+</fullquery>
+
 </queryset>