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 <nisreenqabb...@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 <karamqu...@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 < > > nisreenqabb...@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@lists.katipo.co.nz > >> http://lists.katipo.co.nz/mailman/listinfo/koha > >> > > > > > > > > -- > > *Karam Qubsi* > > > > > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- *Karam Qubsi* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
