Operation Details
Description: Lists all the CitizenCommunicationSendByMailTracker related to a concern role, the concernrole will be found by using communication id.
Sterotype: nsmulti
SQL
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;