https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41726
Bug ID: 41726
Summary: Item search: "Is not" is missing all items where
location/collection is empty
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Cataloging
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
When adding a new item to Koha and not setting a location or collection, they
are set to NULL in the database. This leads to problems with "is not" searches
in the item search. Items with no collection or location are excluded/missing
from search results.
To test:
* Create a new location by adding a new entry to the LOC authorised value
category (so it's not used otherwise)
* Add 2 items to a record
Item A: has the location with the new value
Item B: has no location
Note the title of your record
* Search using the item search:
Title: your title (don't forget to truncate with %)
Verify your 2 items are found
* Amend the search and add to the search criteria:
Location is not <your new location>
* Verify that you get NO results.
Expected behavior: The item with no location should be found
In SQL we can see the difference:
select * from items where location != "something";
Results including NULL/empty locations:
select * from items where location != "something" OR location is NULL;
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
