http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9761 --- Comment #9 from Chris Cormack <chris@bigballofwax.co.nz> --- Comment on attachment 15980 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15980 Bug 9761: Make it possible to confirm future hold requests at checkin time Review of attachment 15980: --> (http://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=9761&attachment=15980) ----------------------------------------------------------------- ::: C4/Reserves.pm @@ +1810,4 @@
AND reserves.reservedate = reserveconstraints.reservedate ) OR reserves.constrainttype='a' ) AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) + AND reserves.reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY)
I was a little worried about adding this constraint, because this column is not indexed, but I tested with some explains and it should be ok. -- You are receiving this mail because: You are watching all bug changes.