Circulation Check in List of Books with in Date wise (Koha SQL Reports Queries)

 Check in List of Books (Date wise)

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

SELECT old_issues.Returndate,

borrowers.Cardnumber AS Card_No,

borrowers.Surname AS Name,

borrowers.borrowernotes AS Department,

borrowers.Categorycode AS Category,

items.Barcode AS Barcode,

biblio.Title AS Title,

biblio.Author AS Author

FROM old_issues  LEFT JOIN borrowers ON borrowers.borrowernumber=old_issues.borrowernumber

LEFT JOIN items ON old_issues.itemnumber=items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber WHERE old_issues.returndate

BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>  ORDER BY old_issues.returndate DESC

Run Report