Glad it worked. All credit to the authors of the reports. This
particular was written by Nicole Engard.
Kind regards,
Lennon Mazonde
On 25/05/2017 18:43, Anastes Mp wrote:
Lol...!
Worked like a charm. Thanks for your support.
On Thu, May 25, 2017 at 5:40 PM, Lennon Mazonde <[email protected]
<mailto:[email protected]>> wrote:
Hi Anastes,
You can find SQL reports from the Koha SQL Reports wiki here
<https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_items_added_by_cataloger_2>.
Go to More > Reports > Create from SQL. Give the report a name
that will help you remember what it's for (or just copy and paste
the details from the SQL Reports wiki).
Then copy and paste the following under the SQL tab.
SELECT concat(p.firstname, ' ', p.surname) AS staff,
concat(a.action, ' ', a.info <http://a.info>) AS action,
count(a.timestamp) AS count
FROM action_logs a
LEFT JOIN borrowers p ON (a.user=p.borrowernumber)
WHERE a.module='CATALOGUING' AND a.timestamp BETWEEN <<Between
(yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
AND a.info <http://a.info> IN ('item','biblio')
GROUP BY p.borrowernumber, concat(a.action, ' ', a.info
<http://a.info>)
Save the report and run it. Oh, you need to turn the
CataloguingLog system preference on (More > Administration >
Global System Preferences > Logs > CataloguingLog.
Kind regards,
Lennon Mazonde
On 25/05/2017 13:48, Anastes Mp wrote:
We've 4 staff in our library for catalog entry and each of them have koha
librarian accounts. We would like analyze their work by counting the total
number of books they entered.
How can we count / generate report on the total number of books entered by
a user?
--
Regards
Anastes Mp
[email protected] <mailto:[email protected]>
+91-9744949078
Facebook <http://www.facebook.com/toanasmp>Google
<https://google.com/+anastes>LinkedInTwitter
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
