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/ > _______________________________________________ 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/
