[Koha-bugs] [Bug 29533] add more fields to items sql table

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Nov 25 17:40:06 CET 2021


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

--- Comment #6 from mathieu saby <mathsabypro at gmail.com> ---
(In reply to Katrin Fischer from comment #4)
> I'd be interested in what your problem with more_subfields_xml is? We have
> quite a bit of data there and no issues.

A collegue from an other library told me it was "clumsy". I cannot say
something more precisely because we are only planning to migrate to Koha and I
am doing some tests. Generally speaking I confess I am not fond of Koha's logic
for managing items (some other ILS I know, and our current one, store item data
in SQL and only map them in MARC for display or export...), but we will adapt.

What I fear mainly with more_subfield_xml is performance problems, if we need
to use ExtractValue() for extracting information from this field in a report.
Maybe am I worrying about nothing, but I have bad memories of ExtractValue()
applied to MARCXML data.

Less important, it will also be more complicated if we want to develop plugins
or patches for customizing or making more parametrable the display of items
(add a new column in OPAC for a information stored in more_subfield_xml )

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


More information about the Koha-bugs mailing list