[Koha-bugs] [Bug 41726] Item search: "Is not" is missing all items where location/collection is empty

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41726 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I am not sure I understand the argument about the SQL standard, because I believe that Koha is not very good about "" vs. NULL and that the normal user doesn't understand that difference. I could also totally imagine that our old data is not super clean in that regard and some libraries have a mix of both options. But I am happy to discuss how we can solve this best! Note: when "" is in location, the search works as expected, it's only the NULL that creates a different result. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.