http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665

Paul A <pau...@aandc.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |pau...@aandc.org

--- Comment #1 from Paul A <pau...@aandc.org> ---
Although not specifically defined, we assume that 001 (Control Number) should
be unique in Koha. Duplicates (for eventual correction) can be found by running
a report:

SELECT GROUP_CONCAT(biblionumber SEPARATOR ', ') AS biblionumbers, 
EXTRACTVALUE(marcxml,'//controlfield[@tag="001"]') AS id FROM biblioitems  
GROUP BY id  HAVING count(id) > 1

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to