https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23081
Aguayo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Aguayo <[email protected]> --- My library has been using the Item Search and also noticed the same problem with the checkout count. I think the problem is related to the "issues" field in the "items" table. The "issues" field is of type SMALLINT with a default value of "null" Using a report, I can illustrate the behavior. Example 1: select barcode, issues from items where issues <= <<equal or less than checkouts>> Result 1: Items with checkouts less or equal to the number you enter are listed but NOT items with 0 checkouts. Same as the Item Search. Example 2: select barcode, issues from items where issues is null OR issues <= <<equal or less than checkouts>> Result 2: Items with checkouts less or equal to the number you enter are listed AND any items with no checkouts. What we would expect to get if looking for check count = 0 or < # My assumption is that Koha displays a '0' when viewing an item on the staff client, however the "items" table stores a "null" value in the "issues" field. Limiting the checkout count with a '0' gives no results because there is no '0' in the "issues" field. If possible the "issues" field needs to have the default value set to '0', or the Item Search code needs to account for a "null" value. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ 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/
