]> 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)
committerwainuiwitikapark <wainuiwitikapark@catalyst.net.nz>
Thu, 12 Sep 2024 06:00:05 +0000 (06:00 +0000)
commitfc8c2ac8c1c8cf01d43d7b7363cb53237bd361bf
treec1a546fa4b498d97eb059df4ded26023c44d9f3e
parent2016b650e2a7691f578a59f2ac4b2c852149278b
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>
catalogue/itemsearch.pl