Database SQL Operation: CitizenCommSendByPostTracker.searchdByConcernRoleIDUsingCommunicationID
Description: | Lists all the CitizenCommunicationSendByMailTracker related to a concern role, the concernrole will be found by using communication id. |
Sterotype: | nsmulti |
SELECT CitizenCommSendByPostTracker.communicationID, CitizenCommSendByPostTracker.requestedDateTime INTO :communicationID, :requestedDateTime
FROM CitizenCommSendByPostTracker
INNER JOIN CONCERNROLECOMMUNICATION
ON CitizenCommSendByPostTracker.communicationid=CONCERNROLECOMMUNICATION.communicationid where CitizenCommSendByPostTracker.communicationid = :communicationID AND CitizenCommSendByPostTracker.communicationPostStatus = :communicationPostStatus;
|