[Koha] SQL Report-Circulation-- Help

[pandu rangaswamy]

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 <lis4satish at 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 at 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