Index: openacs-4/packages/assessment-portlet/www/assessment-portlet-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment-portlet/www/assessment-portlet-postgresql.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/assessment-portlet/www/assessment-portlet-postgresql.xql 8 Jan 2005 16:30:07 -0000 1.2 +++ openacs-4/packages/assessment-portlet/www/assessment-portlet-postgresql.xql 19 Jan 2005 20:56:01 -0000 1.3 @@ -11,7 +11,8 @@ acs_object__name(apm_package__parent_id(crf.package_id)) as parent_name, (select site_node__url(site_nodes.node_id) from site_nodes - where site_nodes.object_id = crf.package_id) as url + where site_nodes.object_id = crf.package_id) as url, + crf.package_id from as_assessments asa, cr_items cri, cr_revisions crr, cr_folders crf where crr.revision_id = asa.assessment_id and crr.revision_id = cri.latest_revision