Index: openacs-4/packages/assessment/www/sessions-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/sessions-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/assessment/www/sessions-postgresql.xql	28 Dec 2004 19:04:59 -0000	1.5
+++ openacs-4/packages/assessment/www/sessions-postgresql.xql	8 Jan 2005 17:27:22 -0000	1.6
@@ -5,7 +5,7 @@
 
 	<fullquery name="sessions_of_assessment">
 		<querytext>
-			SELECT s.session_id, s.completed_datetime, s.percent_score,
+			SELECT r.item_id as assessment_id,s.session_id, s.completed_datetime, s.percent_score,
 			       p.first_names || ' ' || p.last_name AS subject_name,
 			       r.title AS assessment_name, s.subject_id
 			FROM as_sessions s, cr_revisions r, persons p
@@ -19,7 +19,7 @@
 
 	<fullquery name="sessions_of_assessment_of_subject">
 		<querytext>
-			SELECT s.session_id, s.completed_datetime, s.percent_score,
+			SELECT r.item_id as assessment_id, s.session_id, s.completed_datetime, s.percent_score,
 			       p.first_names || ' ' || p.last_name AS subject_name,
 			       r.title AS assessment_name, s.subject_id
 			FROM as_sessions s, cr_revisions r, persons p