Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java =================================================================== diff -u -rc500d9384f365fe8b4c2997a799c44f92e8c26e9 -rc5e0e698afe3abe485c90c6f50ae0326cc46278b --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java (.../AssessmentResultDAOHibernate.java) (revision c500d9384f365fe8b4c2997a799c44f92e8c26e9) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java (.../AssessmentResultDAOHibernate.java) (revision c5e0e698afe3abe485c90c6f50ae0326cc46278b) @@ -54,9 +54,9 @@ + AssessmentResult.class.getName() + " AS r WHERE r.user.userId=? AND r.assessment.uid=? AND (r.finishDate != null)"; - private static final String FIND_ASSESSMENT_RESULT_GRADE = "select r.grade FROM " + private static final String FIND_LAST_ASSESSMENT_RESULT_GRADE = "select r.grade FROM " + AssessmentResult.class.getName() - + " AS r WHERE r.user.userId=? AND r.assessment.uid=? AND (r.finishDate != null)"; + + " AS r WHERE r.user.userId=? AND r.assessment.uid=? AND (r.finishDate != null) ORDER BY r.startDate DESC LIMIT 1"; private static final String FIND_ASSESSMENT_RESULT_TIME_TAKEN = "select r.finishDate - r.startDate FROM " + AssessmentResult.class.getName() @@ -96,7 +96,7 @@ @Override public Float getLastFinishedAssessmentResultGrade(Long assessmentUid, Long userId) { - List list = getHibernateTemplate().find(FIND_ASSESSMENT_RESULT_GRADE, new Object[] { userId, assessmentUid }); + List list = getHibernateTemplate().find(FIND_LAST_ASSESSMENT_RESULT_GRADE, new Object[] { userId, assessmentUid }); if (list == null || list.size() == 0) { return null; } else {