[Koha-bugs] [Bug 24443] Consider NULL as 0 for issues in items search
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Jan 23 12:36:20 CET 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24443
Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #97559|0 |1
is obsolete| |
Attachment #97560|0 |1
is obsolete| |
--- Comment #12 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Created attachment 97801
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=97801&action=edit
Bug 24443: Consider NULL as 0 for issues in items search
In items search, we can filter by items issues count, data coming from
items.issues.
Most of the time, for an item with no issues this column contains NULL.
This enhancement proposes to consider NULL as 0 to allow searching items with
no issues.
Test plan:
1) Use SQL to count items with items.issues = NULL :
select count(*) from items where issues is null;
2) Go to items search
3) Perform search with filter "Checkout count" = 0
4) Check you get the same number of results as SQL query
Signed-off-by: Maryse Simard <maryse.simard at inlibro.com>
Signed-off-by: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list