[Koha-bugs] [Bug 14797] Cancelling orders with no alert to existing holds

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14797

--- Comment #4 from Sandre Cunha <cunha at monterey.org> ---
(In reply to Ray Delahunty from comment #3)
> 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

And then how are the patrons notified?

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.