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.6 -r1.7
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml	17 Feb 2005 02:52:23 -0000	1.6
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml	3 Mar 2005 05:38:32 -0000	1.7
@@ -80,7 +80,9 @@
 		  WHERE ({lesson}.class_grouping_id = lams_grouping.grouping_id)
 		    AND (lams_grouping.grouping_id = lams_group.grouping_id)
 		    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>
 	
 </hibernate-mapping>
Index: lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java,v
diff -u -r1.7 -r1.8
--- lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java	23 Feb 2005 23:01:07 -0000	1.7
+++ lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java	3 Mar 2005 05:38:32 -0000	1.8
@@ -82,15 +82,6 @@
                 }
             }
         );
-    	/*Session session = this.getSession();
-    	try {
-	    	Query query = session.getNamedQuery("activeLessons");
-	    	query.setInteger("userId", learner.getUserId().intValue());
-	    	lessons = query.list();
-    	}
-    	catch (HibernateException e) {
-    		throw new DataRetrievalFailureException(e.getMessage(), e);
-    	}*/
         return lessons;
     }
     
Index: lams_common/test/java/org/lamsfoundation/lams/lesson/dao/TestLessonDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/test/java/org/lamsfoundation/lams/lesson/dao/Attic/TestLessonDAO.java,v
diff -u -r1.6 -r1.7
--- lams_common/test/java/org/lamsfoundation/lams/lesson/dao/TestLessonDAO.java	17 Feb 2005 22:41:41 -0000	1.6
+++ lams_common/test/java/org/lamsfoundation/lams/lesson/dao/TestLessonDAO.java	3 Mar 2005 05:38:32 -0000	1.7
@@ -9,6 +9,8 @@
 
 package org.lamsfoundation.lams.lesson.dao;
 
+import java.util.List;
+
 import org.lamsfoundation.lams.lesson.Lesson;
 import org.lamsfoundation.lams.lesson.LessonDataAccessTestCase;
 
@@ -56,6 +58,13 @@
         
     }
 
+    public void testGetActiveLessonsForLearner()
+    {
+        List lessons = this.lessonDao.getActiveLessonsForLearner(this.testUser);
+        
+        assertEquals("verify the number of lesson we get",0,lessons.size());
+    }
+    
     public void testUpdateLesson()
     {
         Lesson createdLesson = this.lessonDao.getLesson(this.testLesson.getLessonId());
@@ -68,5 +77,10 @@
         Lesson updatedLesson = lessonDao.getLesson(testLesson.getLessonId());
         
         assertEquals("verify the updated lesson state",Lesson.STARTED_STATE,updatedLesson.getLessonStateId());
+    
+        List lessons = this.lessonDao.getActiveLessonsForLearner(this.testUser);
+        
+        assertEquals("verify the number of lesson we get",1,lessons.size());
+
     }
 }