[Koha] Another report request -- Active Cardholders
bibliwho at gmail.com
Thu Feb 10 11:11:57 NZDT 2011
Thank you, Bev!
Seems to work fine for our small library.
The only improvement would be to be able to specify a date range, the
syntax for which isn't immediately obvious to me.
Thank you again,
Cab Vinton, Director
Sanbornton Public Library
On Wed, Feb 9, 2011 at 4:48 PM, Church, Beverly <bchurch at liblime.com> wrote:
> 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,
More information about the Koha