[Koha] Report for bibs with multiple items with item details

[Michael May]

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 at bywatersolutions.com]
Sent: Tuesday, December 20, 2016 8:45 AM
To: Michael May <mmay at dubuque.lib.ia.us>
Cc: koha at 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 at dubuque.lib.ia.us<mailto:mmay at 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.