https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14797
--- Comment #3 from Ray Delahunty <[email protected]> --- 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. _______________________________________________ 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/
