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_... 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§ion=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*
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@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_... 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§ion=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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Cecil Yes the logs must be turned on because I used the action_logs table which requires this . Best regards On Tue, Jun 3, 2014 at 10:35 PM, Hillyard, Cecil <CHillyard@washoecounty.us> wrote:
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@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_...
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§ion=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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
Hi all sorry there were a mistake in the reports in these lines : AND I.info!='biblio' >> AND I.info='biblio' AND I.info!='item' >> AND I.info='item' ( i fixed them on the wiki page ) Best wishes :) On Tue, Jun 3, 2014 at 6:01 PM, Karam Qubsi <karamqubsi@gmail.com> wrote:
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_...
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§ion=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*
-- *Karam Qubsi*
participants (2)
-
Hillyard, Cecil -
Karam Qubsi