[Koha] Renew Report

[Jonathan Druart]

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 <arshadsanwal at gmail.com> 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>>, at 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
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>