[Koha-devel] found = Null in CancelReserve

[BOUIS Sonia]

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<http://bu.univ-lyon3.fr/>

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20151002/2ecd7174/attachment.html>