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 <[email protected]> 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 <[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
