http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9761
--- Comment #9 from Chris Cormack <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
