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

Check Out List of Books (Date wise)

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

SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date,

p.cardnumber AS Card_No,

p.surname AS Name,

p.borrowernotes AS Department,

p.Categorycode AS Category,

i.barcode AS Barcode,

b.title AS Title,

b.author AS Author,

p.branchcode AS Library

FROM issues c

LEFT JOIN items i ON (c.itemnumber=i.itemnumber)

LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber)

LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)

WHERE c.issuedate

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

Run Report