[Koha] number of bibliographic records

[Karam Qubsi]

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 :

actionbibsADD193DELETE10MODIFY1010
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
<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*