Index: openacs-4/packages/assessment-portlet/www/assessment-portlet.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment-portlet/www/Attic/assessment-portlet.xql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/assessment-portlet/www/assessment-portlet.xql	17 Feb 2006 12:17:58 -0000	1.4
+++ openacs-4/packages/assessment-portlet/www/assessment-portlet.xql	7 Apr 2006 23:12:50 -0000	1.5
@@ -4,19 +4,17 @@
 <fullquery name="answered_assessments">
 	<querytext>
 select ass.*, sc.node_id as comm_node_id, sa.node_id as as_node_id, p.instance_name as community_name from 
-(select cr.item_id as assessment_id, cr.title, cr.description,
-	cf.package_id
-	from as_assessments a, cr_revisions cr, cr_items ci, cr_folders cf,
-	(select distinct s.assessment_id
-		from as_sessions s
-		where s.subject_id = :user_id
-		and s.completed_datetime is not null) s
-		where a.assessment_id = cr.revision_id
-		and cr.revision_id = ci.latest_revision
-		and ci.parent_id = cf.folder_id
-		$package_id_sql
-		and s.assessment_id = a.assessment_id
-		) ass, 
+  (select cr.item_id as assessment_id, cr.title, cr.description, cf.package_id
+   from as_assessments a, cr_revisions cr, cr_items ci, cr_folders cf,
+      (  select distinct s.assessment_id
+         from as_sessions s
+         where s.subject_id = :user_id
+         and s.completed_datetime is not null) s
+         where a.assessment_id = cr.revision_id --
+         and cr.item_id = ci.item_id
+         and ci.parent_id = cf.folder_id
+         and s.assessment_id = a.assessment_id
+       ) ass, 
 site_nodes sa, site_nodes sc, apm_packages p
 where sa.object_id = ass.package_id
 and sc.node_id = sa.parent_id