Re: [Koha] Report for bibs with multiple items with item details
I apologize. I've figured out how to add biblionumbers to a report of all items, and then how to identify and isolate duplicates in the downloaded spreadsheet. This pretty much does what I want. Thanks for listening. :) -Mike From: Michael May Sent: Monday, December 19, 2016 12:04 PM To: 'koha@lists.katipo.co.nz' <koha@lists.katipo.co.nz> Subject: Report for bibs with multiple items with item details Hi all, I need to weed DVDs that have multiple copies, so I'm trying to find a downloadable Koha report that shows all bibs with multiple items which includes details about all of those items, like barcodes, call numbers, and loan statuses. I see reports at https://wiki.koha-community.org/wiki/SQL_Reports_Library which show bibs with item counts, but I'm hoping to get specific details about those items. Is this the right place to ask for help with this? Thank you. Mike Michael May Adult Services Librarian Carnegie-Stout Public Library 360 West 11th Street Dubuque, IA 52001-4697, USA Phone: 563-589-4225 ext. 2244 Fax: 563-589-4217 Email: mmay@dubuque.lib.ia.us<mailto:mmay@dubuque.lib.ia.us> Web: www.dubuque.lib.ia.us<http://www.dubuque.lib.ia.us/>
On Mon, Dec 19, 2016 at 1:25 PM, Michael May <mmay@dubuque.lib.ia.us> wrote:
I apologize. I've figured out how to add biblionumbers to a report of all items, and then how to identify and isolate duplicates in the downloaded spreadsheet. This pretty much does what I want. Thanks for listening. :) -Mike
No need to apologize -- would you mind giving a more detailed description of what you did? Thanks! --Barton
Hi Barton, I’m using this report: SELECT biblio.biblionumber,(select count(*) from reserves where biblionumber=biblio.biblionumber) as holdsonbib, items.barcode,items.itemcallnumber,biblio.title,items.issues,items.itemnotes,items.enumchron,items.onloan,items.notforloan,items.damaged,items.itemlost,items.withdrawn,items.datelastborrowed,items.datelastseen,items.dateaccessioned FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.ccode='XDVDBR' ORDER BY biblio.biblionumber I’m downloading the report as tab separated text, opening in Excel, conditional formatting the biblionumber column to highlight duplicate values in red, and filtering by cell color. Mike From: Barton Chittenden [mailto:barton@bywatersolutions.com] Sent: Tuesday, December 20, 2016 8:45 AM To: Michael May <mmay@dubuque.lib.ia.us> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Report for bibs with multiple items with item details On Mon, Dec 19, 2016 at 1:25 PM, Michael May <mmay@dubuque.lib.ia.us<mailto:mmay@dubuque.lib.ia.us>> wrote: I apologize. I've figured out how to add biblionumbers to a report of all items, and then how to identify and isolate duplicates in the downloaded spreadsheet. This pretty much does what I want. Thanks for listening. :) -Mike No need to apologize -- would you mind giving a more detailed description of what you did? Thanks! --Barton Click here<https://www.mailcontrol.com/sr/xBfa6Ks6MQ3GX2PQPOmvUubKwjUTrb0OnVqnnCxrXurEf54fsRkDBtg31lSFhtsBEGEwoHiksOqsCq9I+zBdpQ==> to report this email as spam.
participants (2)
-
Barton Chittenden -
Michael May