[Koha] SQL for report on items Catalouged by each librarian per period

Carlos Lopez clopez at dml.vic.edu.au
Fri Apr 26 12:21:52 NZST 2019


Hi Akin

There's a report in the SQL Reports Library that seems to do what you want (https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_bibs_modified_by_cataloger) (it looks at the action_logs table for module CATALOGING and action MODIFY (not CREATE))

With kind regards from the Dalton McCaughey Library Team

Carlos Lopez

Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052
Ph: 03 9340 8888 ext.1 | library at dml.vic.edu.au | library.dmlibrary.org.au 

-----Original Message-----
From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of Akin Adigun (Akinomatics)
Sent: Friday, 26 April 2019 6:24 AM
To: koha at lists.katipo.co.nz
Subject: [Koha] SQL for report on items Catalouged by each librarian per period

Hello pls i need ur help, i want an sql query for report to generate the number of books calalogued by all librarians, but i am finding it difficult becos acquisition librarian is always the one entering the biblio in our case since all materials must pass through acquisitions.


_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
-- 
Message  protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.http://www.mailguard.com.au/mg
Click here to report this message as spam:
https://console.mailguard.com.au/ras/1VzXqjiRGX/4RzIekbc2oLoZMneccsXkq/3.5



More information about the Koha mailing list