[Koha] Circulation report limited with date

[Nicole Engard]

Anyone can edit the wiki, so you're welcome to add the report since
you wrote the bulk of it anyway :)

Nicole

On Tue, Apr 19, 2011 at 11:30 PM, Vimal Kumar <vimal0212 at gmail.com> wrote:
> Dear Nicole,
>
> Thank u for the SQL query.
>
> Can u make arrangement to add this query in koha wiki Report library?
>
> Ragrads,
>
> Vimal
>
> On Tue, Apr 19, 2011 at 8:08 PM, Nicole Engard <nengard at gmail.com> wrote:
>>
>> 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
>> >
>> >
>
>