<font size="2"><font face="verdana,sans-serif">Hi Cab,<br><br>Try this query. It uses the statistics table which contains both current and history checkouts. The query looks for any patron whose most recent checkout was on or after a specified date. The main disadvantage to this report is that it could time out if the statistics table is very big.<br>
<br>select borrowers.surname, borrowers.firstname, borrowers.cardnumber, borrowers.categorycode, borrowers.dateexpiry from statistics, borrowers where statistics.borrowernumber = borrowers.borrowernumber and statistics.type = 'issue' group by statistics.borrowernumber having max(date(datetime)) >= 'YYYY-MM-DD' order by borrowers.surname, borrowers.firstname<br>
<br>Bev<br clear="all"></font></font><br>* * * * <br>Beverly Church <br>LibLime Project Manager<br><br>phone: 1-888-564-2457 ext. 717 <br> 1-301-654-8088 ext. 292<br>email: <a href="mailto:bchurch@liblime.com" target="_blank">bchurch@liblime.com</a><br>
skype: beverlychurch<br>
<br><br><div class="gmail_quote">On Wed, Feb 9, 2011 at 4:20 PM, Cab Vinton <span dir="ltr"><<a href="mailto:bibliwho@gmail.com">bibliwho@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;">
There is a promising report on the Koha wiki (List Active Patrons by<br>
Category for a Specific Month). However, it doesn't seem to be<br>
providing valid results, even after changing "old_issues" to "issues".<br>
(The latter change produces counts in the single digits.)<br>
<br>
We're looking for a count of active borrowers between two dates,<br>
broken down by categorycode. ("Active" meaning at least one checkout<br>
between the two dates.)<br>
<br>
Appreciate any help!<br>
<font color="#888888"><br>
Cab Vinton, Director<br>
Sanbornton Public Library<br>
Sanbornton, NH<br>
_______________________________________________<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>
</font></blockquote></div><br>