[Koha] Renew Report

[Arshad Iqbal]

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.