[Koha-bugs] [Bug 33514] SearchWithIS[B|S]NVariations breaks ISBN search in item search

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

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

--- Comment #4 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to Tomás Cohen Arazi from comment #3)
> (In reply to Katrin Fischer from comment #2)
> > I am not sure what the best solution here is:
> 
> What about making sure that normalized strings are always stored on the DB?
> (i.e. no spaces, no symbols). It feels like GetVariationsOfISBN might be too
> much in my opinion.

I think that's not the main issue here, sorting differently would not resolve
hte issue. We need to fix the search query. The problem is that we store a
string of space separated ISBN and you can't search that with SQL without
truncating/using LIKE. And that's what happens now and only works when there is
only one ISBN on the record (which often is not the case at least for us)

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