Index: lams_common/src/java/org/lamsfoundation/lams/gradebook/dao/hibernate/GradebookDAO.java =================================================================== diff -u -r1f6366dd975a5f5079cb57b2ca53e77873f5cb96 -r9f8cc8f4efd6e0e3e36ba0a160f8f9e0ba107b9c --- lams_common/src/java/org/lamsfoundation/lams/gradebook/dao/hibernate/GradebookDAO.java (.../GradebookDAO.java) (revision 1f6366dd975a5f5079cb57b2ca53e77873f5cb96) +++ lams_common/src/java/org/lamsfoundation/lams/gradebook/dao/hibernate/GradebookDAO.java (.../GradebookDAO.java) (revision 9f8cc8f4efd6e0e3e36ba0a160f8f9e0ba107b9c) @@ -422,7 +422,7 @@ "AND lesson.lessonClass.groupingId = g.grouping.groupingId " + "AND ug.group.groupId = g.groupId " + "AND CONCAT(ug.user.lastName, ' ', ug.user.firstName) LIKE CONCAT('%', :searchString, '%') " + - "AND completedActivityProgress.learnerProgress.lesson.lessonId = :lessonId" + + "AND completedActivityProgress.learnerProgress.lesson.lessonId = :lessonId " + "AND completedActivityProgress.learnerProgress.user.userId = ug.user.userId " + "AND completedActivityProgress.activity.activityId = :activityId " + "ORDER BY TIMEDIFF(completedActivityProgress.finishDate, completedActivityProgress.startDate) " + sortOrder;