Index: openacs-4/packages/assessment/www/sessions.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/sessions.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/assessment/www/sessions.xql	22 Sep 2004 19:36:32 -0000	1.3
+++ openacs-4/packages/assessment/www/sessions.xql	23 Sep 2004 14:20:56 -0000	1.4
@@ -10,5 +10,13 @@
 			WHERE as_sessionsx.assessment_id=:assessment_id
 		</querytext>
 	</fullquery>
+
+	<fullquery name="sessions_of_assessment_of_subject">
+		<querytext>
+			SELECT as_sessionsx.session_id, as_sessionsx.name, as_sessionsx.title, as_sessionsx.completed_datetime, as_sessionsx.subject_id, persons.first_names || ' ' || persons.last_name AS subject_name, as_assessmentsx.title AS assessment_name
+			FROM (as_sessionsx INNER JOIN as_assessments ON as_sessionsx.assessment_id = as_assessments.assessment_id) INNER JOIN persons ON as_sessionsx.subject_id = persons.person_id
+			WHERE as_sessionsx.assessment_id=:assessment_id AND as_sessionsx.subject_id=:subject_id
+		</querytext>
+	</fullquery>
 	
 </queryset>