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.14.1 -r1.1.14.2 --- openacs-4/packages/assessment/www/asm-admin/index-postgresql.xql 4 Jul 2016 11:23:05 -0000 1.1.14.1 +++ openacs-4/packages/assessment/www/asm-admin/index-postgresql.xql 4 Jul 2016 11:35:25 -0000 1.1.14.2 @@ -20,7 +20,7 @@ select ci.item_id as assessment_id, cr.title, ci.publish_status - from cr_items ci, cr_revisions cr + 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