Hi Andrea,
Hope, this will help you.
-
Developer: Heather Braum - hbr...@nekls.org
Ciao, Andrea.
Maybe
SELECT DISTINCT(biblionumber), count(biblionumber)
FROM items
GROUP BY biblionumber
HAVING count(biblionumber) 1
can help you.
sb
I'd need to write a report for finding records with multiple items in
them: any suggestions?
TIA
Andrea Furin
On 06/02/15 07:17, andrea.fu...@slacky.it wrote:
Hi.
I'd need to write a report for finding records with multiple items in
them: any suggestions?
TIA
Andrea Furin
Hi Andrea,
You may find the report you need in the reports library:
http://wiki.koha-community.org/wiki/SQL_Reports_Library
I hope
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
Hi.
I'd need to write a report for finding records with multiple items in
them: any suggestions?
TIA
Andrea Furin
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
5 matches
Mail list logo