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

[Liz Rea]

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 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 would be great if
> the report showed the number of days or the hold expiration date.
>
> Many thanks,
>
> Vanda
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: OpenPGP digital signature
URL: <https://lists.katipo.co.nz/pipermail/koha/attachments/20170302/3a58fbed/attachment.sig>