[Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

Hi everybody, I would like to run a report that would show me all the users, their e-mail adresses, titles and barcodes of items whose holds have been waiting for pickup longer than the ReservesMaxPickupDelay number of days (in our case 7 days). Can anyone please help me with the SQL Report? It w

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

Hi, In the Koha interface, you can go to Circulation -> Holds awaiting pickup and have a look at the "Hold(s) over" tab. This should show you the information you are wanting. Cheers, Liz Rea Catalyst IT On 01/03/17 23:16, vanda koha wrote: > Hi everybody, > > I would like to run a report that w

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

fredhutch.org<http://www.fredhutch.org/> Date: Wed, 1 Mar 2017 10:16:06 + From: vanda koha mailto:vandak...@gmail.com>> To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: [Koha] SQL report for holds waiting for pickup longer tha

Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days

FRED HUTCH / CURES START HERE > fredhutch.org<http://www.fredhutch.org/> > > > > > Date: Wed, 1 Mar 2017 10:16:06 + > > From: vanda koha mailto:vandak...@gmail.com>> > > To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > > Subjec