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 <[email protected]> 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 <[email protected]>: > > 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 > > [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > >
_______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
