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@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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha