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.3 -r1.4
--- openacs-4/packages/assessment/www/sessions-postgresql.xql	20 Dec 2004 14:01:46 -0000	1.3
+++ openacs-4/packages/assessment/www/sessions-postgresql.xql	22 Dec 2004 20:52:17 -0000	1.4
@@ -10,8 +10,22 @@
 			       a.title AS assessment_name, s.subject_id
 			FROM as_sessionsx s INNER JOIN as_assessmentsx a USING (assessment_id)
 			INNER JOIN persons p ON (s.subject_id = p.person_id)
-			WHERE s.assessment_id = :assessment_id
+			WHERE s.assessment_id = :assessment_rev_id
 			AND s.subject_id = :subject_id
+			ORDER BY s.completed_datetime desc, s.creation_datetime desc
 		</querytext>
 	</fullquery>	
+
+	<fullquery name="sessions_of_assessment_of_subject">
+		<querytext>
+			SELECT s.session_id, s.name, s.title, s.completed_datetime, s.percent_score,
+			       p.first_names || ' ' || p.last_name AS subject_name,
+			       a.title AS assessment_name, s.subject_id
+			FROM as_sessionsx s INNER JOIN as_assessmentsx a USING (assessment_id)
+			INNER JOIN persons p ON (s.subject_id = p.person_id)
+			WHERE s.assessment_id = :assessment_rev_id
+			ORDER BY s.completed_datetime desc, s.creation_datetime desc
+		</querytext>
+	</fullquery>	
+
 </queryset>