[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

Jonathan Druart <jonathan.druart+koha at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart+koha at gmail.
                   |                            |com

--- Comment #38 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
(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?

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