Report Name: Total Messages send to particular Member

Purpose: It will help in providing total different type of messages information sent to specific user in case of any conflict and misunderstanding
Status: Complete tested on Koha 16.11.07




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

FROM message_queue r

LEFT JOIN borrowers b ON b.borrowernumber=r.borrowernumber

WHERE b.cardnumber LIKE <<Member ID>>  AND r.letter_code IN
('ODUE', 'DUE','PREDUE','CHECKIN','CHECKOUT','RENEWAL','HOLD') AND STATUS = 'sent' 
GROUP BY year(r.time_queued), month(r.time_queued), r.letter_code