[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