[Koha-bugs] [Bug 5790] Deleting a biblio should alert/fail if there are existent subscriptions and holds

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5790

--- Comment #1 from Liz Rea <wizzyrea at gmail.com> 2011-02-22 15:43:26 UTC ---
Here is a report that will show you bibs that have no items, but have orphan
holds. 

To delete the holds (or notify patrons that the hold is being deleted due to no
items in the collection), you will need to create a dummy item to see the
holds.

SELECT DISTINCT biblio.biblionumber, biblio.title FROM biblio LEFT JOIN items
ON
biblio.biblionumber = items.biblionumber LEFT JOIN reserves ON
biblio.biblionumber = reserves.biblionumber WHERE items.itemnumber IS NULL and
reserves.borrowernumber IS NOT NULL

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.