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 <karamqu...@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_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§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* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha