Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java =================================================================== diff -u -r8d884816c85e11d6939c0ac03be4c8514c800439 -r972a6ad0f5b132096ca0e844ea3edf36ab9bf522 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java (.../McUsrAttemptDAO.java) (revision 8d884816c85e11d6939c0ac03be4c8514c800439) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java (.../McUsrAttemptDAO.java) (revision 972a6ad0f5b132096ca0e844ea3edf36ab9bf522) @@ -46,6 +46,8 @@ private static final String LOAD_ATTEMPT_FOR_USER = "from mcUsrAttempt in class McUsrAttempt where mcUsrAttempt.queUsrId=:queUsrId"; + private static final String LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT = "from mcUsrAttempt in class McUsrAttempt where mcUsrAttempt.queUsrId=:queUsrId and mcUsrAttempt.mcQueContentId=:mcQueContentId"; + private static final String LOAD_ATTEMPT_BY_ATTEMPT_ORDER = "from mcUsrAttempt in class McUsrAttempt where mcUsrAttempt.queUsrId=:queUsrId and mcUsrAttempt.mcQueContentId=:mcQueContentId and attemptOrder=:attemptOrder"; private static final String LOAD_MARK = "from mcUsrAttempt in class McUsrAttempt"; @@ -101,6 +103,18 @@ return list; } + public List getAttemptsForUserAndQuestionContent(final Long queUsrId, final Long mcQueContentId) + { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT) + .setLong("queUsrId", queUsrId.longValue()) + .setLong("mcQueContentId", mcQueContentId.longValue()) + .list(); + + return list; + } + + public List getAttemptForQueContent(final Long queUsrId, final Long mcQueContentId) { HibernateTemplate templ = this.getHibernateTemplate();