Bug 24443: Consider NULL as 0 for issues in items search
authorFridolin Somers <fridolin.somers@biblibre.com>
Fri, 17 Jan 2020 09:25:19 +0000 (10:25 +0100)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 24 Jan 2020 12:49:06 +0000 (12:49 +0000)
commit80f1374f262544a750b5d81a7d9605c8708c53b1
tree7c18459b4a73a12871c1bb03a228413693aeaba3
parent2ee96d2abd9037723a8e844d1d6ed1c1c3a0c556
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@inlibro.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
C4/Items.pm