[Koha] SQL statement for generating current checkouts

Church, Beverly bchurch at liblime.com
Thu Apr 21 00:16:50 NZST 2011


Nabonita,

You can use this query if you want to see the title:

SELECT issues.issuedate, items.barcode, biblio.title,
borrowers.firstname,borrowers.surname, borrowers.cardnumber,
borrowers.categorycode FROM issues LEFT JOIN borrowers ON
borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON
issues.itemnumber = items.itemnumber LEFT JOIN biblio ON
items.biblionumber=biblio.biblionumber WHERE issues.issuedate = 'yyyy-mm-dd'

If you don't need the title, use this query:

SELECT issues.issuedate, items.barcode, borrowers.firstname,
borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues
LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT
JOIN items ON issues.itemnumber = items.itemnumber WHERE issues.issuedate =
'yyyy-mm-dd'



* * * *
Beverly Church
LibLime Project Manager

phone: 1-888-564-2457 ext. 717
            1-301-654-8088 ext. 292
email: bchurch at liblime.com
skype: beverlychurch


2011/4/20 nabonita Guha <nabonita at jncasr.ac.in>

> Dear Koha users/Developers,
>
> Can you please help me in building SQL statement to generate current
> checkouts on a given date (not for a date range). For example, I need to
> generate a report to get list of (barcodes with borrowers card number,
> surname and firstname and borrower's category with date of issue) were on
> Loan as on 2011-03-29.
>
> Looking forward to hearing from you.
>
> With best regards
>
> Nabonita
>
> --
> Nabonita Guha
> Library-cum-Information Officer
> Library, Jawaharlal Nehru Centre
> for Advanced Scientific Research,
> Jakkur Post, Bangalore 560064
> Karnataka, India
> Phone: +91-80-22082930
> Email: nabonita at jncasr.ac.in
> Web: http://lib.jncasr.ac.in
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110420/228c4b7a/attachment.htm 


More information about the Koha mailing list