[Koha] Circulation report limited with date

Vimal Kumar vimal0212 at gmail.com
Wed Apr 20 15:30:02 NZST 2011


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
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110420/19b92e52/attachment.htm 


More information about the Koha mailing list