[Koha] Circulation report limited with date

[Nicole Engard]

If you're putting it to the Koha reports tool you can use this:

SELECT issues.issuedate,items.barcode,biblio.title,
author,borrowers.firstname,borrowers.surname 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 BETWEEN
<<Between Date (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>> ORDER BY
issues.issuedate

If you're doing it on the command line you can do this:

SELECT issues.issuedate,items.barcode,biblio.title,
author,borrowers.firstname,borrowers.surname 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 BETWEEN
'date1' and 'date2' ORDER BY issues.issuedate

Thanks
Nicole C. Engard

2011/4/19 Vimal Kumar <vimal0212 at gmail.com>:
> Dear Friends,
> I could generate the current checkouts with  following SQL query:
>
> SELECT issues.issuedate,items.barcode,biblio.title,
> author,borrowers.firstname,borrowers.surname 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 ORDER BY issues.issuedate
>
> Please help me to generate the same as per date limit. For example: I need
> to generate report of current checkouts as of 29th March 2011. How shall I
> modify the query so that I  can get the report limited with date.
>
> With best regards
>
>
> --
> Vimal Kumar V.
> Mahatma Gandhi University Library
> Kottayam, Kerala- 686 560
> Web: http://www.vimalkumar.co.nr
> Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com
> ---------------------------------------------------------------------------
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>