[Koha-bugs] [Bug 14797] Cancelling orders with no alert to existing holds
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Aug 15 12:14:31 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14797
--- Comment #3 from Ray Delahunty <r.delahunty at 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.
More information about the Koha-bugs
mailing list