Dear All, Currently i am using Koha version 3.12.10.000. and i am having two branch libraries.
I am looking in SQL report to generate the books details with the following details. 1. Title of the book 2. Author 3. Publisher 4. Place of Publication and year 5. Name of the vendor 6. Invoice No and Date 7. Price 8. Withdrawn status Kindly guide to get the report. Thanks Pandu. +91-8978002982 On Wed, Feb 22, 2017 at 3:35 PM, SATISH <lis4sat...@gmail.com> wrote: > Hi, > > With Koha 16.5/Package Installation/ Ubuntu 14.04 Desktop / > > I looking for Borrower's complete transactions report between "date range" > and "by patron category" and "by itemtype". > I reason for the report is: to keep the record in hard copy for entire > semester's transactions. > > I am trying following report, with date range, am successful but when added > patron category and itemtype (last two line in WHERE section), it's > failing. > > Can someone help me to get this report or please correct me, if I am wrong > in the query?? > > ------------------------------------------------------------ > ------------------------------------------ > SELECT borrowers.cardnumber, borrowers.surname,borrowers.firstname, > borrowers.streetnumber, borrowers.categorycode,items.barcode, > DATE_FORMAT(old_issues.issuedate, "%d %b %Y %h:%i %p") As issuedate, > DATE_FORMAT(old_issues.date_due, "%d %b %Y %h:%i %p") As date_due, > DATE_FORMAT(old_issues.lastreneweddate, "%d %b %Y %h:%i %p") As > lastreneweddate, > DATE_FORMAT(old_issues.returndate, "%d %b %Y %h:%i %p") As returndate, > EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' ) > AS TITLE, > items.itype, items.location, items.ccode,items.itemcallnumber, items.price > FROM old_issues > LEFT JOIN borrowers ON ( borrowers.borrowernumber = > old_issues.borrowernumber ) > LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber ) > LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber = > b.biblioitemnumber) > WHERE p.categorycode=<<categorycode|categorycode>> AND > WHERE items.itype=<<itemtypes|itemtypes>> AND > WHERE old_issues.issuedate BETWEEN <<Between Date (yyyy-mm-dd)|date>> and > <<and (yyyy-mm-dd)|date>> ORDER BY old_issues.issuedate > ------------------------------------------------------------ > ---------------------------------------- > > With Thanks > Satish MV > Librarian > Govt. Engineering College, Hassan > Karnataka. > www.gechassan.ac.in > -- > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- M.Pandu Rangaswamy H.T.Parekh Library Institute For Financial Management and Research (IFMR) 24, Kothari Road, Chennai - 600 034 INDIA Tel - 91-44-2830 3498 Mobile: 08978002982 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha