[Koha] Statistic for daily catalogers achievement in date range

Karam Qubsi karamqubsi at gmail.com
Wed Jun 4 13:52:13 NZST 2014


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 at 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 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
>
>


-- 
*Karam Qubsi*


More information about the Koha mailing list