Re: [Koha] A report for finding records with multiple items?

2015-02-06 Thread SATISH
Hi Andrea, Hope, this will help you. - Developer: Heather Braum - hbr...@nekls.org

Re: [Koha] A report for finding records with multiple items?

2015-02-06 Thread Stefano Bargioni
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

Re: [Koha] A report for finding records with multiple items?

2015-02-05 Thread Bob Birchall
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

Re: [Koha] A report for finding records with multiple items?

2015-02-05 Thread Roberts, David
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

[Koha] A report for finding records with multiple items?

2015-02-05 Thread andrea.fu...@slacky.it
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