[Koha] Expired Patrons with Checkouts

[Hartman, David W. - GBTS Library]

Hello list,

  
   I upgraded Koha to 3.09.00.004 but it still won't save the search.  Any other thoughts?  I logged off and on and created the search again but it won't save.


>
> -----Original Message-----
> From: Nicole Engard [mailto:nengard at gmail.com]
> Sent: Monday, August 27, 2012 10:56 AM
> To: Hartman, David W. - GBTS Library
> Subject: Re: [Koha] Expired Patrons with Checkouts
>
> 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
> Nicole
>
> 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