Thank you very much
On Wed, Feb 19, 2014 at 5:34 AM, Karam Qubsi <karamqu...@gmail.com> wrote: > Hi , > in my library I'm using this report , and I think this is the same report > you want : > > SELECT l.action, count(l.timestamp) AS 'bibs' > FROM action_logs l > LEFT JOIN borrowers p ON (p.borrowernumber=l.user) > WHERE module='CATALOGUING' > AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and > (yyyy-mm-dd)>> > AND l.info!='item' AND user=<<user no.>> > GROUP BY l.action > > > this report will ask you for date range and cataloger no . then the > results would be something like this : > > action bibs ADD 193 DELETE 10 MODIFY 1010 > Note : the above report is modified by me the source is here : > http://wiki.koha-community.org/wiki/SQL_Reports_Library where the report > name there is : > > - 5.83 Bib records added/deleted in time > frame<http://wiki.koha-community.org/wiki/SQL_Reports_Library#Bib_records_added.2Fdeleted_in_time_frame> > developed > by Nicole C. Engard, ByWater Solutions > - > > Best wishes . > > > On Thu, Feb 13, 2014 at 11:21 PM, Nisreen Qabbani < > nisreenqabb...@gmail.com> wrote: > >> Hello >> Can you help me how to know the number of bibliographic records for each >> employee account >> >> Thank you very much >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > *Karam Qubsi* > > > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
