public List<SupplementAnswer> getUnapprovedAnswerList() {
return commonDao.query(
SupplementAnswer.class,
"SELECT A.*, B.TITLE AS PARENT_ANSWER_TITLE FROM SUPPLEMENT_ANSWER A LEFT JOIN ANSWER B ON A.ANSWER_ID = B.ID WHERE A.IS_ACTIVE = 1 AND A.IS_APPROVED = 0 ORDER BY UPDATE_DATETIME DESC");
}
public List<SupplementAnswer> getSuppleAnswerList(int answerId) {
return commonDao.query(
SupplementAnswer.class,
"SELECT * FROM SUPPLEMENT_ANSWER WHERE ANSWER_ID = ? AND IS_ACTIVE = 1 AND IS_APPROVED = 1 ORDER BY UPDATE_DATETIME",
answerId);
}