https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25603
--- Comment #11 from Mark Hofstetter <[email protected]> --- actually extractvalue is no problem if you do it like this - we have this working for libraries with 1M+ records alter table biblio_metadata add column controlnumber varchar(100) GENERATED ALWAYS AS (trim(extractvalue(metadata,'//controlfield[@tag="001"]'))) STORED create index controlnumber_ind on biblio_metadata (controlnumber); What we are doing at the moment is to implement OAI-PMH for a customer where the identifier is the controlnumber So in the OAI method of concern we'll simply look up the biblionumber for the given identifer (in our case the controlnumber) but 001+003 or 035a would also be trivial -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
