Summary: | Item search: collection search doesn’t work correctly when searching 'collection is not' | ||
---|---|---|---|
Product: | Koha | Reporter: | Kati Sillgren <kati.sillgren> |
Component: | Searching | Assignee: | Bugs List <koha-bugs> |
Status: | NEW --- | QA Contact: | Testopia <testopia> |
Severity: | new feature | ||
Priority: | P5 - low | CC: | katariina.pohto |
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: | Circulation function: |
Description
Kati Sillgren
2024-09-11 07:39:03 UTC
This seems to happen with some other values that can be NULL. In the drop down menu with the barcode placeholder there can be several different options working the same way, for example age restriction or series. If you search items while selecting these as "is not", the results will not include the items that have a NULL value. It seems to be the way SQL works. Even reports will not give you the NULL results if you search for items with (CCODE != collection) but you can circumvent it using (CCODE IS NULL OR CCODE !=CCODE). This is how our librarians think it should work in item search. (And if we changed this logic it would still be possible to do the CCODE search the way it was, by selecting 'Collection IS' and making the multiple choice of all the collections but the ones excluded.) |