Report Name: Notices sent to patrons during date range

Purpose: Count of various type of notices sent in a specific time frame like overdue, renewal, hold, purchase request status etc.
Status: Complete tested on Koha 16.11.07



SELECT monthname(message_queue.time_queued) AS 'Month', year(message_queue.time_queued) AS 'Year',        message_queue.letter_code AS 'Notice Code', message_queue.subject AS 'Subject', count(message_queue.borrowernumber) AS count 

FROM message_queue 

WHERE message_queue.time_queued BETWEEN <<Sent BETWEEN (yyyy-mm-dd)|date>>AND <<and (yyyy-mm-dd)|date>>       AND message_queue.letter_code IN ('ODUE', 'DUE', 'PREDUE','CHECKIN','CHECKOUT','RENEWAL','HOLD','ACCEPTED','AVAILABLE','ORDERED','ACCTDETAILS')      AND STATUS = 'sent' GROUP BY year(message_queue.time_queued), month(message_queue.time_queued), message_queue.letter_code