private buildGetTriageGroupMembersQuery ( |
||
groupId | ||
return | OracleQuery |
public void testGetTriageGroupMemberIdsSqlStatement() { UserDao dao = new UserDao(_cxn); OracleQuery query = dao.buildGetTriageGroupMembersQuery(1); Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT CTM.USER_ID, USR.EMAIL_ADDRESS, USR.OPLOCK, USR.EMAIL_NOTIFICATION, USR.LAST_EMAIL_NOTIFICATION FROM SMS.CLINICIAN_TRIAGE_MAP CTM JOIN SMS.SMS_USER USR ON CTM.USER_ID=USR.USER_ID WHERE CTM.TRIAGE_GROUP_ID=:groupId AND CTM.ACTIVE=1")); }
public void testGetTriageGroupMemberIdsSqlStatement() { UserDao dao = new UserDao(_cxn); OracleQuery query = dao.buildGetTriageGroupMembersQuery(1); Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT CTM.USER_ID, USR.EMAIL_ADDRESS, USR.OPLOCK, USR.EMAIL_NOTIFICATION, USR.LAST_EMAIL_NOTIFICATION FROM SMS.CLINICIAN_TRIAGE_MAP CTM JOIN SMS.SMS_USER USR ON CTM.USER_ID=USR.USER_ID WHERE CTM.TRIAGE_GROUP_ID=:groupId AND CTM.ACTIVE=1")); }