We are using CS16.2.7 and within our Production environment I am looking to urgently compile a Live Report which provides me with the full Recipient List, Acknowledger and Acknowledgement dates of a Transmittal that was sent
So far I can see the following fields, but it is only returning a single user who acknowledged the transmittal rather than all recipients it was sent to.
Please can someone advise what the SQL syntax is required to pickup the full Recipient List and the Acknowledgment date?
The SQL code I'm using is:
select d2.dataid as Transmittal_DataID, d2.name as Transmittal_Name, tr.delivery_time Delivery_Time,
d.DataID as Recipient_ID, d.name as Recipient,ta.acknowledgement
from trans_recipients tr
inner join trans_recip_ack ta on ta.trans_id = tr.trans_id and ta.recipient_id = tr.recipient_id
inner join DTree d on d.DataID = tr.recipient_id
inner join DTree d2 on d2.DataID = tr.trans_id
where tr.ack_type = 1
and ta.acknowledgement = 1
order by d2.Name
