Index: openacs-4/packages/assessment/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/index.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/assessment/www/index.xql	7 Oct 2004 13:30:26 -0000	1.3
+++ openacs-4/packages/assessment/www/index.xql	22 Dec 2004 20:52:17 -0000	1.4
@@ -3,8 +3,10 @@
 
 	<fullquery name="asssessment_id_name_definition">
 		<querytext>
-			SELECT assessment_id, name, title, description
-			FROM as_assessmentsx
+			select cr.item_id as assessment_id, cr.title, cr.description
+			from as_assessments a, cr_revisions cr, cr_items ci
+			where a.assessment_id = cr.revision_id
+			and cr.revision_id = ci.latest_revision
 		</querytext>
 	</fullquery>