[Koha-bugs] [Bug 23919] Make ISSN searchable with and without hyphen
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Sun May 14 17:35:13 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23919
--- Comment #39 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to Jonathan Druart from comment #38)
> (In reply to Katrin Fischer from comment #37)
> > I am sad to say, but adding this to item search was not a great idea :(
> >
> > Item search is SQL based, not a search engine, which changes things quite a
> > bit.
> >
> > We are exploding the search now with up to 4 forms of ISBN into something
> > like:
> >
> > isbn like 'isbn1' or isbn like 'isbn2' ...
> >
> > But: We are not truncating.
> >
> > As soon as there is more than one ISBN or ISSN (these are repeatable fields)
> > or the library actually follows MARC21 standard adding ISBD punctuation,
> > this fails. We store in biblioitems.isbn like this:
> >
> > isbn1 ; | isbn2 ; | isbn3.
> > isbn1.
> >
> > This also seems to create quite a performance issue on big databases and it
> > can't be turned off separately from the normal search.
> >
> > I've filed bug 33514.
>
> Can you please address bug 33514? In the meanwhile should we remove this?
What do you mean with "address"? It's all explained there as well.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list