3 Sep
2021
3 Sep
'21
1:28 p.m.
Good morning, This report allows you to view the number of items entered for each Librarian. SELECT concat(p.firstname, ' ', p.surname) AS Operador, concat(a.action, ' ', a.info) AS Ação, count(a.timestamp) AS Quantidade FROM action_logs a LEFT JOIN borrowers p ON (a.user=p.borrowernumber) WHERE a.module='CATALOGUING' AND a.timestamp BETWEEN <<Data Inicial (dd.mm.yyy)|date>> AND <<Data Final (dd.mm.yyy)|date>> AND a.info IN ('item','biblio') GROUP BY p.borrowernumber, concat(a.action, ' ', a.info) How can I change this report to show the listing of titles entered by each Librarian?