]> git.koha-community.org Git - koha.git/commit
Bug 36930: Item search gives irrelevant results when using 2+ added filter criteria
authorJanusz Kaczmarek <januszop@gmail.com>
Wed, 22 May 2024 21:08:35 +0000 (21:08 +0000)
committerFrédéric Demians <f.demians@tamil.fr>
Mon, 7 Oct 2024 17:05:08 +0000 (19:05 +0200)
commit01e8c21439afa8b28735b03037839da9dd723639
tree45c4861e95bf7819e3249695a93b013bba2b486b
parent0f1c1f11b35241daf12c359915ec7767b8196cff
Bug 36930: Item search gives irrelevant results when using 2+ added filter criteria

In the Item search the librarian is allowed, in the first step, to define
additional filters like Title, Author, Publisher, Publication date etc.
(in the third fieldset).  This works fine but only for one criterion.
If one adds two or more criteria, the filter does not apply at all.

Test plan
=========
1. Make an Item search with the Pulblisher filter. Put
   %University of California% as the value.
   You should get 5 rows (with standard ktd test data set), three
   from 1982, and two from 1988.
2. Edit search -> add the second criterion: AND Publication date is 1982.
   You would expect three rows but you get 900+ rows.
3. Apply the patch; restart_all.
4. Repeat p. 2. You should get the expected three rows.

Signed-off-by: Pedro Amorim <pedro.amorim@ptfs-europe.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit bdc7ac2c93f9af9ac196c77da47758a1078c47d7)
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
(cherry picked from commit dca760d5b24428143a0e0de7b52c131c813488fc)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Signed-off-by: wainuiwitikapark <wainuiwitikapark@catalyst.net.nz>
(cherry picked from commit fc8c2ac8c1c8cf01d43d7b7363cb53237bd361bf)
Signed-off-by: Frédéric Demians <f.demians@tamil.fr>
catalogue/itemsearch.pl