http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1824 Summary: pending reserves shows *everything* will not work for large libraries Product: Koha Version: rel_3_0 Platform: All URL: http://smfpl-beta.dev.kohalibrary.com:8080/cgi- bin/koha/circ/pendingreserves.pl OS/Version: All Status: NEW Severity: major Priority: P3 Component: Circulation AssignedTo: chris@bigballofwax.co.nz ReportedBy: drdrulm@yahoo.com QAContact: koha-bugs@nongnu.org The pending reserver report in circ http://smfpl-beta.dev.kohalibrary.com:8080/cgi-bin/koha/circ/pendingreserves... show *everything* including items that are not on the shelf. I gave some code to Josh F. for this from the group of utilities I wrote in PHP to deal with this. My code is specific in that it hard codes some of the cancel dates, but there is no reason the SQL and algorithm could not be taken from this report and put into the pendingreserves.pl I have my own test Koha3 going now and I can make modifications and all that. Does anyone want me to translate my code from PHP and alter this report? This report as it stands gives everything, even items that are not available on the shelf. Since this is a daily pull list, we ONLY should show the items that can be grabbed off the shelves. The checked out items and lost items are of no use, as are the items already on the hold shelf. Does anyone want my PHP. I may be able to get time to put this into the new Koha, but not in a few weeks. Also, my code does not work by branch, although it would be easy to modify it to use the "set branch" param. At least the default option should be for available. This requires looking at the status of the item including the authorized values, which is a pain but required. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.