[Koha-bugs] [Bug 13023] Nonpublic note for items should be mapped to a database column like itemnotes

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Jul 26 05:01:33 CEST 2017


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13023

--- Comment #32 from David Cook <dcook at prosentient.com.au> ---
(In reply to Katrin Fischer from comment #30)
> David, take a look at: misc/batchRebuildItemsTables.pl -c
> But beware, it's slow.

I only had a few thousand records to touch in a database with over a million
records, so I gave it one of these and it completed pretty quickly:

perl batchRebuildItemsTables.pl -c --where="biblio.biblionumber in (select
biblionumber from items where more_subfields_xml is not null group by
biblionumber)"

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list