[Koha] Statistic for daily catalogers achievement in date range

[Hillyard, Cecil]

Does this require the cataloging logs to be turned on?  Ours our turned off because it slows down things too much.

__________________________
Cecil Hillyard
Washoe County Library
-Tel: 775-327-8338 or 7750-327-8330
fax: 775-327-8334

-----Original Message-----
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Karam Qubsi
Sent: Tuesday, June 03, 2014 3:02 AM
To: Koha
Subject: [Koha] Statistic for daily catalogers achievement in date range

Hi all ,
some libraries need to monitor the achievement of their catalogers  , I added 2 new reports to the wiki page , I hope it will be helpful for some libraries .

http://wiki.koha-community.org/wiki/SQL_Reports_Library#Statistic_for_daily_catalogers_achievement_in_date_range_for_bib_records

Statistic for daily catalogers achievement in date range for bib records

   - *Developer:* Karam Qubsi
   - *Module:* Cataloging
   - *Purpose:* Statistic for daily catalogers achievement in date range
   for bib records (you can change the date range I make it for the whole 2014
   year in this example )
   - *Status:* Complete

SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff,
count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD'
AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31'
 AND I.info!='biblio'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC

[edit
<http://wiki.koha-community.org/w/index.php?title=SQL_Reports_Library&action=edit&section=264>
]Statistic for daily catalogers achievement in date range for Item records

   - *Developer:* Karam Qubsi
   - *Module:* Cataloging
   - *Purpose:* Statistic for daily catalogers achievement in date range
   for item records (you can change the date range I make it for the whole
   2014 year in this example )
   - *Status:* Complete

SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff,
count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD'
AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31'
 AND I.info!='item'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC


Bests

--
*Karam Qubsi*
_______________________________________________
Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha