How look like the new version of the query? On Mon, 23 Apr 2018 at 12:02 Arshad Iqbal <[email protected]> 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 < > [email protected]> wrote: > >> 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 <[email protected]> wrote: >> >>> Hi, >>> I want to convert this checked in sql report into renew sql report. How i >>> can convert this report. guide me. >>> >>> SELECT b.title, b.author, i.itemcallnumber, i.barcode, c.returndate >>> FROM (SELECT iss.returndate, iss.itemnumber FROM issues iss, >>> (SELECT @StartDate:=<<Between (yyyy-mm-dd)|date>>,@EndDate:=<<and >>> (yyyy-mm-dd)|date>>) AS var >>> WHERE date(iss.returndate) BETWEEN @StartDate AND @EndDate UNION ALL >>> SELECT oi.returndate, oi.itemnumber FROM old_issues oi WHERE >>> date(oi.returndate) >>> BETWEEN @StartDate AND @EndDate) AS c >>> LEFT JOIN items i USING (itemnumber) >>> LEFT JOIN biblio b USING (biblionumber) >>> WHERE i.homebranch=<<Item belongs TO|branches>> >>> >>> -- >>> >>> >>> *Muhammad Arshad Iqbal* >>> Assistant Librarian at Publishing and Student Affairs Directorate, >>> National University of Science and Technology (NUST) Islamabad. >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> [email protected] >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> > > > -- > > > *Muhammad Arshad Iqbal* > Assistant Librarian at Publishing and Student Affairs Directorate, > National University of Science and Technology (NUST) Islamabad. > Phone number:051-90851371 > Cell no.+923444900809 <+92%20344%204900809> > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
