Dear All, I am running Koha 17.11.04.000 in Ubuntu at CBSE school. I have created new field Student class and section in Additional attributes and identifiers. Every day we are taking circulation report "Date wise list of Checked out Books" and also Checked in books. Is it possible to include student class and section in this report. It will be very useful for us. If it is possible, can you please guide me? I will be thankful to you.
Report SQL: 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, i.barcode AS Barcode, b.title AS Title, b.author AS Author, p.cardnumber AS Card_No, p.firstname AS First_Name, p.surname AS Last_Name 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 '2019-02-07' AND '2019-02-08' ORDER BY c.issuedate DESC Thank you, Ashok Francis New Delhi _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha