[Koha-devel] found = Null in CancelReserve

[Katrin Fischer]

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