[Koha] Another report request -- Active Cardholders

Cab Vinton 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
Sanbornton, NH

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,
> borrowers.firstname

More information about the Koha mailing list