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 <karamqubsi@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@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@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@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*