Hi,

We are working on hold stuff at the moment and we have a lot of questions !

We want to provide statistics on canceled holds to know if they haven’t been picked-up as waiting for the borrower or if the expiration_date on hold have been passed.

But if we can see if a hold is waiting in found column of reserves table, this information disappeared from old_reserves table.

In C4/Reserves.pm, there’s this SQL request in CancelReserve :

UPDATE reserves

            SET    cancellationdate = now(),

                   found            = Null,

                   priority         = 0

            WHERE  reserve_id = ?

I’m not a specialist, but I wonder why found is set to Null when cancelling and why we can’t keep this information in old_reserves ?

Thanks in advance for any explanation.

Cheers,

Sonia BOUIS

Responsable du Système intégré de gestion des bibliothèques

bIBLIOTHÈQUES UNIVERSITAIRES

Université Jean Moulin Lyon 3

6 Cours Albert Thomas - B.P. 8242 – 69355 Lyon Cedex 08

ligne directe : +33 (0)4 78 78 79 03 | http://bu.univ-lyon3.fr

L'Université Jean Moulin est membre fondateur de l'Université de Lyon