Thank you so much MAMSET LIBRARY. It works well. Great work.
On Fri, Feb 8, 2019 at 9:14 AM MAMCET Library <mamcet.librar...@gmail.com> wrote: > Report form Checked out > 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, > p.cardnumber AS Card_No, > p.firstname AS First_Name, > p.surname AS Last_Name, > p.borrowernotes AS Class_section , > 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 > > On Fri, Feb 8, 2019 at 9:02 AM MAMCET Library <mamcet.librar...@gmail.com> > wrote: > >> Report Checked in report >> >> SELECT old_issues.Returndate, >> borrowers.Cardnumber AS Card_No, >> borrowers.Surname AS Name, >> borrowers.borrowernotes AS Class, >> 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 >> >> On Thu, Feb 7, 2019 at 1:12 PM Ashok Francis <ashokfrancis....@gmail.com> >> wrote: >> >>> 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 >>> >> >> >> -- >> Thanking you.. >> >> Librarian, >> MAMCET <http://mamcet.com/> >> Trichy-Chennai Trunk Road, >> Siruganur, Tiruchirappalli-621 105. >> >> > > -- > Thanking you.. > > Librarian, > MAMCET <http://mamcet.com/> > Trichy-Chennai Trunk Road, > Siruganur, Tiruchirappalli-621 105. > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha