Re: [Koha] How to get statistic for borrowed item by borrower with department

2019-04-23 Thread ikbar
hi katrin yes, im run them in koha -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to get statistic for borrowed item by borrower with department

2019-04-22 Thread Katrin Fischer
Hi ikbar, which of the statements did you try to run? Did you run them in Koha or in an SQL editor? Please make sure there is no whitespace before the SELECT at the very beginning. Katrin On 17.04.19 12:17, ikbar wrote: hi katrin thanks for helping me but i do run the script but an error occu

Re: [Koha] How to get statistic for borrowed item by borrower with department

2019-04-17 Thread ikbar
hi katrin thanks for helping me but i do run the script but an error occurs >The following error was encountered: The database returned the following error: called with 2 bind variables when 0 are needed Please check the log for further details. Return to previous page < as you told me : - Keep

Re: [Koha] How to get statistic for borrowed item by borrower with department

2019-04-14 Thread Katrin Fischer
Hi ikbar, a list of patrons with the number of current checkouts (not returned yet) ordered by department could look something like that: SELECT   sort1 as department,   cardnumber,   surname,   firstname,   (select count(*) from issues i where i.borrowernumber = b.borrowernumber) as Checkouts F

Re: [Koha] How to get statistic for borrowed item by borrower with department

2019-04-07 Thread ikbar
Department stored at Sort 1 Let me tell the situation : Do you just need the number of checkouts, borrower information and department? > YES Or a list with one line for each item? > Also YES add a timestamp My english is not good... anyway tq an advance for helping me katrin -- Se

Re: [Koha] How to get statistic for borrowed item by borrower with department

2019-04-05 Thread Katrin Fischer
Hi ikbar, where do you store the department? Is it the library/branch or some other field in the borrower? Do you just need the number of checkouts, borrower information and department? Or a list with one line for each item? Katrin On 05.04.19 11:44, ikbar wrote: Hi all master I need help wi