Index: openacs-4/packages/assessment/www/asm-admin/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/index-postgresql.xql,v
diff -u -N -r1.1 -r1.1.14.1
--- openacs-4/packages/assessment/www/asm-admin/index-postgresql.xql	1 Feb 2005 22:00:10 -0000	1.1
+++ openacs-4/packages/assessment/www/asm-admin/index-postgresql.xql	4 Jul 2016 11:23:05 -0000	1.1.14.1
@@ -16,5 +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>