[Koha] number of bibliographic records

[Nisreen Qabbani]

Thank you very much



On Wed, Feb 19, 2014 at 5:34 AM, Karam Qubsi <karamqubsi at 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 <
> 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*
>
>
>
>