[Koha] report to show the listing of titles entered by each Librarian

Victor Barroso Oliveira vbovictor at gmail.com
Fri Sep 3 23:28:05 NZST 2021


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?


More information about the Koha mailing list