Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml,v
diff -u -r1.9 -r1.10
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml	7 Mar 2005 05:09:03 -0000	1.9
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml	6 Apr 2005 04:04:51 -0000	1.10
@@ -93,7 +93,14 @@
 		    AND (lams_group.group_id = lams_user_group.group_id)
 		    AND ({lesson}.lesson_state_id IN (3,4,5))		    
 		    AND (lams_user_group.user_id = :userId)
-
 	</sql-query>
 	
+	<sql-query name="activeLearners">
+		<return alias="learner" class="org.lamsfoundation.lams.usermanagement.User" />
+		SELECT DISTINCT {learner.*}
+		  FROM lams_user {learner},
+		       lams_learner_progress
+		  WHERE ({learner}.user_id = lams_learner_progress.user_id)
+		  AND   (lams_learner_progress.lesson_id  = :lessonId)
+	</sql-query>
 </hibernate-mapping>