Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java,v diff -u -r1.18.2.12 -r1.18.2.13 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java 14 Jul 2016 05:37:47 -0000 1.18.2.12 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java 26 Jul 2016 02:44:49 -0000 1.18.2.13 @@ -107,8 +107,8 @@ } private static final String SQL_LOAD_ATTEMPT_FOR_SESSION_AND_QUESTION_LIMIT_WITH_NAME_SEARCH_AVG_RATING1 = "SELECT resp.*, AVG(rating.rating) avg_rating" - + " FROM tl_laqa11_usr_resp resp WHERE resp.answer IS NOT NULL" + " JOIN tl_laqa11_que_usr usr" - + " ON resp.qa_que_content_id = :questionId AND resp.que_usr_id = usr.uid " + + " FROM tl_laqa11_usr_resp resp" + " JOIN tl_laqa11_que_usr usr" + + " ON resp.answer IS NOT NULL AND resp.qa_que_content_id = :questionId AND resp.que_usr_id = usr.uid " + " AND usr.que_usr_id!=:excludeUserId " + " JOIN tl_laqa11_session sess " + " ON usr.qa_session_id = sess.uid AND sess.qa_session_id = :qaSessionId "; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaLearningAction.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaLearningAction.java,v diff -u -r1.53.2.25 -r1.53.2.26 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaLearningAction.java 14 Jul 2016 05:37:47 -0000 1.53.2.25 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaLearningAction.java 26 Jul 2016 02:44:49 -0000 1.53.2.26 @@ -1097,9 +1097,6 @@ responcedata.put(AttributeNames.ATTR_COUNT_RATED_ITEMS, countRatedQuestions); } - // setting date format to ISO8601 for jquery.timeago - DateFormat dateFormatterTimeAgo = new SimpleDateFormat(DateUtil.ISO8601_FORMAT); - dateFormatterTimeAgo.setTimeZone(TimeZone.getTimeZone("GMT")); for (QaUsrResp response : responses) { QaQueUsr user = response.getQaQueUser(); @@ -1126,7 +1123,7 @@ // in the server time zone. Date attemptTime = response.getAttemptTime(); responseRow.put("attemptTime", DateUtil.convertToStringForJSON(attemptTime, request.getLocale())); - responseRow.put("timeAgo", dateFormatterTimeAgo.format(attemptTime)); + responseRow.put("timeAgo", DateUtil.convertToStringForTimeagoJSON(attemptTime)); if (isAllowRateAnswers) { Index: lams_tool_laqa/web/monitoring/MonitoringMaincontent.jsp =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/monitoring/MonitoringMaincontent.jsp,v diff -u -r1.39.2.15 -r1.39.2.16 --- lams_tool_laqa/web/monitoring/MonitoringMaincontent.jsp 14 Jul 2016 05:37:47 -0000 1.39.2.15 +++ lams_tool_laqa/web/monitoring/MonitoringMaincontent.jsp 26 Jul 2016 02:44:49 -0000 1.39.2.16 @@ -91,7 +91,9 @@ + +