Hello We are our steps, but I do not know where the mistake Is it a Patron ID Or the card number or the report and thank you very much
On Mon, Mar 3, 2014 at 11:13 AM, Karam Qubsi <karamqu...@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 > <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
