Dear Nicole,<br><br>Thank u for the SQL query.<br><br>Can u make arrangement to add this query in koha wiki Report library?<br><br>Ragrads,<br><br>Vimal<br><br><div class="gmail_quote">On Tue, Apr 19, 2011 at 8:08 PM, Nicole Engard <span dir="ltr"><<a href="mailto:nengard@gmail.com">nengard@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">If you're putting it to the Koha reports tool you can use this:<br>
<div class="im"><br>
SELECT issues.issuedate,items.barcode,biblio.title,<br>
author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN<br>
borrowers ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN<br>
items ON issues.itemnumber=items.itemnumber LEFT JOIN biblio ON<br>
</div>items.biblionumber=biblio.biblionumber WHERE issues.issuedate BETWEEN<br>
<<Between Date (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>> ORDER BY<br>
issues.issuedate<br>
<br>
If you're doing it on the command line you can do this:<br>
<div class="im"><br>
SELECT issues.issuedate,items.barcode,biblio.title,<br>
author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN<br>
borrowers ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN<br>
items ON issues.itemnumber=items.itemnumber LEFT JOIN biblio ON<br>
</div>items.biblionumber=biblio.biblionumber WHERE issues.issuedate BETWEEN<br>
'date1' and 'date2' ORDER BY issues.issuedate<br>
<br>
Thanks<br>
Nicole C. Engard<br>
<br>
2011/4/19 Vimal Kumar <<a href="mailto:vimal0212@gmail.com">vimal0212@gmail.com</a>>:<br>
<div><div></div><div class="h5">> Dear Friends,<br>
> I could generate the current checkouts with following SQL query:<br>
><br>
> SELECT issues.issuedate,items.barcode,biblio.title,<br>
> author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN borrowers<br>
> ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN items ON<br>
> issues.itemnumber=items.itemnumber LEFT JOIN biblio ON<br>
> items.biblionumber=biblio.biblionumber ORDER BY issues.issuedate<br>
><br>
> Please help me to generate the same as per date limit. For example: I need<br>
> to generate report of current checkouts as of 29th March 2011. How shall I<br>
> modify the query so that I can get the report limited with date.<br>
><br>
> With best regards<br>
><br>
><br>
> --<br>
> Vimal Kumar V.<br>
> Mahatma Gandhi University Library<br>
> Kottayam, Kerala- 686 560<br>
> Web: <a href="http://www.vimalkumar.co.nr" target="_blank">http://www.vimalkumar.co.nr</a><br>
> Blog: <a href="http://vimalkumar.oksociety.in" target="_blank">http://vimalkumar.oksociety.in</a> <a href="http://linuxhalwa.blogspot.com" target="_blank">http://linuxhalwa.blogspot.com</a><br>
> ---------------------------------------------------------------------------<br>
> "I forget what I was taught. I only remember what I have learnt"<br>
> -Patrick White<br>
><br>
</div></div>> _______________________________________________<br>
> Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
> <a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
><br>
><br>
</blockquote></div><br>