[Koha] number of bibliographic records

[Karam Qubsi]

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*