This was a bug in a previous version of Koha. What version are you on? You might want to upgrade to 3.8.4.
Nicole On Mon, Aug 27, 2012 at 11:53 AM, Hartman, David W. - GBTS Library <david.w.hart...@disney.com> wrote: > One problem ... I cannot get it to save in my saved reports? > > I go through the steps for "create from SQL" and then save and it does not > show up in my list of saved reports. > > I have tried twice.. could it be a rights issue? > > -----Original Message----- > From: Nicole Engard [mailto:neng...@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.hart...@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@lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
