[Koha] number of bibliographic records

Karam Qubsi karamqubsi at gmail.com
Wed Feb 19 15:34:40 NZDT 2014

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)
      AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and
      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 :

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
   by Nicole C. Engard, ByWater Solutions

Best wishes .

On Thu, Feb 13, 2014 at 11:21 PM, Nisreen Qabbani
<nisreenqabbani at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

*Karam Qubsi*

More information about the Koha mailing list