You may want to try this query: select title,count(*) from biblio group by title having count(*) > 1 On Thu, Jul 23, 2009 at 4:05 PM, Nicole Engard <nicole.engard@liblime.com>wrote:
You might want to list your report request here: http://wiki.koha.org/doku.php?id=sql_library And when you get an answer make sure you share it with all of us on that page :)
---
Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce@liblime.com AIM/Y!/Skype: nengard
http://liblime.com http://blogs.liblime.com/open-sesame/
Hi everyone-
We’re a hosted Koha library using whatever the most recent release of the product is. I’ve been asked if I can generate a report through Koha that would tell us all the duplicate items in the collection. Try as I might, I can’t seem to figure out a simple way of doing this without pulling a report of every single item, sorting by call number, and sifting through the tens of thousands of items. Has anyone generated a report like this? It wouldn’t be enough to pull titles that have more than one record because then we’ll get multi-volume sets too. And there isn’t a single identifying entry in
2009/7/23 Banks, Joy M <jbanks@flsouthern.edu>: the
call number (e.g. pt. or c.) because there hasn’t been any consistency with our tracking of duplicate items. If anyone has ideas, please let me know. I’ll only be able to copy/paste generated SQL into the Report Wizard. We have no access to the backend of the system.
Thank you!
~Joy
Joy M. Banks
Catalog Librarian
Roux Library
Florida Southern College
111 Lake Hollingsworth Dr.
Lakeland, FL 33801
(863)680-4736
jbanks@flsouthern.edu
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- ----------------- Beverly Church Project Manager - LibLime phone: 1.888.564.2457 x717 email: beverly.church@liblime.com skype: beverlychurch