Hi Sonia, I have been thinking about this, but see no reason not to keep the found status when moving the hold. I think we are not using the data in old_reserves. Can you file a bug report please? Katrin Am 02.10.2015 um 14:27 schrieb 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/*
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/