[Koha] Expired Patrons with Checkouts

[Nicole Engard]

Forgot to hit reply to all!

This will do what you want (I think):


select p.surname, p.firstname, p.cardnumber, p.dateexpiry,
count(c.itemnumber) as 'items out'
from borrowers p
left join issues c using (borrowernumber)
where p.dateexpiry < now() and p.borrowernumber in (select
borrowernumber from issues)
group by p.borrowernumber


Thanks

On Mon, Aug 27, 2012 at 10:23 AM, Hartman, David W. - GBTS Library
<David.W.Hartman at disney.com> wrote:
> Hello!
>
>   Is there a report in Koha to notify the librarian about the expired patrons who still have items checked out? I did not see one but I'd like to see a report of the expired patrons who have not returned their items.]
>
> David
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha