Re: [Koha] Renew Report

SELECT b.title, b.author, i.itemcallnumber, i.barcode, c.renewaldate FROM (SELECT iss.renewaldate, iss.itemnumber FROM issues iss, (SELECT @StartDate:=<>,@EndDate:=<>) AS var WHERE date(iss.returndate) BETWEEN @StartDate AND @EndDate UNION ALL SELECT oi.renewaldate, oi.itemnumber FROM old_issues

Re: [Koha] Renew Report

How look like the new version of the query? On Mon, 23 Apr 2018 at 12:02 Arshad Iqbal wrote: > I have added reneweddate and renwal as well in sql report but working not > good > On Mon, Apr 23, 2018 at 7:38 PM, Jonathan Druart < > jonathan.dru...@bugs.koha-community.org>

Re: [Koha] Renew Report

I have added reneweddate and renwal as well in sql report but working not good On Mon, Apr 23, 2018 at 7:38 PM, Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Hello Arshad, > > The renew information is in the same tables issues/old_issues, there are > lastreneweddate and

Re: [Koha] Renew Report

Hello Arshad, The renew information is in the same tables issues/old_issues, there are lastreneweddate and renewals. Note that asking the question only once is enough :) Regards, Jonathan On Mon, 23 Apr 2018 at 10:47 Arshad Iqbal wrote: > Hi, > I want to convert this