[Koha-bugs] [Bug 23919] Make ISSN searchable with and without hyphen

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #37 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
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.

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