Deletion of Multiple item Records
Hi I have a user who have attached a number of multiple records in the cataloguing Module using the Add Multiple Item button. I would like an SQL command that will enable us to delete both the items and biblioitems records in a range. Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263771117777 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>
I have a user who have attached a number of multiple records in the cataloguing Module using the Add Multiple Item button.
If the items are all attached to a single bibliographic record, you don't need any custom SQL command. Open the record in the staff client catalog, e.g. /cgi-bin/koha/catalogue/detail.pl?biblionumber=1234 In the holdings tab, select all the items you want to delete and click the 'Delete selected items' link. This will pass the selected items to the batch item deletion tool. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
participants (2)
-
Admire Mutsikiwa -
Owen Leonard