[Bug 14797] Cancelling orders with no alert to existing holds
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14797 --- Comment #3 from Ray Delahunty <r.delahunty@arts.ac.uk> --- This remains a problem in 3.20 (we move to 16.05 soon). As a workaround we have set up a report to be run whenever an order is cancelled, to look for reservations. We have added this to the homepage, and our cataloging / acquisitions staff can easily access it. SELECT o.ordernumber, b.title, b.author, p.surname, p.firstname, r.reservedate, r.cancellationdate, r.branchcode FROM reserves r LEFT JOIN borrowers p USING (borrowernumber) LEFT JOIN biblio b USING (biblionumber) LEFT JOIN aqorders o USING (biblionumber) LEFT JOIN aqbasket n using (basketno) WHERE o.ordernumber=<<Order number>> Better than nothing I suppose. Ray Delahunty University of the Arts London -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org