Index: openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql 30 Aug 2004 08:41:53 -0000 1.5 +++ openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql 30 Aug 2004 09:04:20 -0000 1.6 @@ -10,8 +10,8 @@ eg.grade_id, eg.grade_item_id from evaluation_gradesx eg, acs_objects ao - where (select count(*) from cr_items - where live_revision = eg.grade_id) > 0 + where exists (select 1 from cr_items + where live_revision = eg.grade_id) and eg.item_id = ao.object_id and ao.context_id in ([join $list_of_package_ids ,]) order by grade_plural_name desc