https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33514 --- Comment #4 from Katrin Fischer <katrin.fischer@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.