https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14797
--- Comment #4 from Sandre Cunha <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
