I haven't actually tried this, but there is a report in the Koha SQL
Reports library that looks like it can be adapted to do what you want. The
report is called "Records with item count". I reckon you just need to add a
'HAVING' clause which identifies records with more than one copy:
*SELECT DISTINCT
CONCAT('<a title="Search for all records sharing the
title:',b.title,'" href="/cgi-bin/koha/catalogue/search.pl?q=ti%3A
<http://search.pl?q=ti%3A>',
REPLACE(REPLACE (b.title, ' ', '+'),'?',''),'">Search</a>') AS
"Search for Title",
b.biblionumber,
CONCAT('<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=
<http://detail.pl?biblionumber=>',b.biblionumber,'">',b.title,'</a>')
AS "Item Title",
b.author,
t.editionstatement,
t.publishercode,
t.isbn,
count(i.biblionumber) AS "Copies"
FROM biblio b
LEFT JOIN biblioitems t USING(biblionumber)
LEFT JOIN items i USING(biblionumber)
GROUP BY b.biblionumber
HAVING copies > 1
ORDER BY Copies ASC*
Like I say, I haven't tested it, but I think it should work. Somebody else
may have a better way.
Cheers
David
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 05 Feb 2015 21:17:40 +0100
> From: "andrea.fu...@slacky.it" <andrea.fu...@slacky.it>
> To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz>
> Subject: [Koha] A report for finding records with multiple items?
> Message-ID: <54d3cfe4.3060...@slacky.it>
> Content-Type: text/plain; charset=windows-1252
>
> Hi.
> I'd need to write a report for finding records with multiple items in
> them: any suggestions?
> TIA
>
> Andrea Furin
>
>
> ------------------------------
>
--
David Roberts
Customer Support Consultant.
PTFS Europe Ltd.
david.robe...@ptfs-europe.com
Skype: david.roberts.2
http://www.ptfs-europe.com
<http://t.sigopn04.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4QBdV-N3MyblvcW5ggVd76_W56dGPkf7SXhKs02?t=http%3A%2F%2Fwww.ptfs-europe.com%2F&si=4884665740034048&pi=a94240f2-184a-4f0b-da6b-c66d57fd7536>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
