From 2c0060447b2ccd794d4b4e441d0bc9005caeb7a4 Mon Sep 17 00:00:00 2001 From: Shi Yao Wang Date: Fri, 23 Feb 2024 14:16:27 -0500 Subject: [PATCH] Bug 35916: Purchase suggestions bibliographic filter should be a "contains" search Make all bibliographic information fields filter do a contain match rather than an exact match Test plan: 1. Create a purchase suggestion with a multi-word title (e.g. one day in december) 1.1. Go to Acquisitions > Suggestions > New purchase suggestion 1.2. Enter a title (e.g. one day in december) 1.3. Click on Submit your suggestion 2. Search for one of the words in the title 2.1. In the "Filter by" section, click on Bibliographic information 2.2. In the title field, enter one of the words of the title (e.g. december) 2.3. Click Go --> No results 3. Apply the patch 4. Redo step 2 and notice there is now a valid result Signed-off-by: David Nind --- suggestion/suggestion.pl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/suggestion/suggestion.pl b/suggestion/suggestion.pl index cb6da835f3..4b00fa0056 100755 --- a/suggestion/suggestion.pl +++ b/suggestion/suggestion.pl @@ -424,6 +424,9 @@ if ($op=~/else/) { if $search_params->{$f} eq '__ANY__' || $search_params->{$f} eq ''; } + for my $bi (qw (title author isbn publishercode copyrightdate collectiontitle)) { + $search_params->{$bi} = { 'LIKE' => "%" . $search_params->{$bi} . "%" } if $search_params->{$bi}; + } $search_params->{archived} = 0 if !$filter_archived; my @suggestions = Koha::Suggestions->search_limited($search_params)->as_list; -- 2.30.2