[Koha] number of bibliographic records

[Nisreen Qabbani]

Oak

Iam Going to try it

Thanks Karam


On Mon, Mar 3, 2014 at 12:13 PM, Karam Qubsi <karamqubsi at gmail.com> wrote:

> hi you should put  the user id no.
>  not the username .
> it's something like : (1 , 2 , 3 ... )
> you can check the userid from the user record .
>
> Best regards
>
>
> On Mon, Mar 3, 2014 at 2:53 PM, Nisreen Qabbani <nisreenqabbani at gmail.com>wrote:
>
>> Have tried that
>> But there was a problem
>> After placing
>>
>> 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
>>
>>
>> The origin of the SQL reports
>> And specify the date and name
>> Does not show results, but shows the same instructions
>> What is the problem
>>
>>
>>
>> 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*
>>
>> >
>> >
>> >
>> >
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>
> --
> *Karam Qubsi*
>
>
>
>