Bug 33969 - Purchase suggestion Search (title filter) only exact match
Summary: Purchase suggestion Search (title filter) only exact match
Status: RESOLVED DUPLICATE of bug 27278
Alias: None
Product: Koha
Classification: Unclassified
Component: Acquisitions (show other bugs)
Version: 23.05
Hardware: All All
: P5 - low normal with 10 votes (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-09 11:19 UTC by Barry Cannon
Modified: 2023-06-09 13:22 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Workflow of purchase suggestions search (89.22 KB, application/pdf)
2023-06-09 11:19 UTC, Barry Cannon
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Barry Cannon 2023-06-09 11:19:29 UTC
Created attachment 152238 [details]
Workflow of purchase suggestions search

If a borrower logs into the OPAC and searches for a Purchase Suggestion it will only return hits if the exact string is entered (see attached).

Looking at the underlying query it preforms an exact match on `title`. 

SELECT `me`.`suggestionid`, `me`.`suggestedby`, `me`.`suggesteddate`, `me`.`managedby`, `me`.`manageddate`, `me`.`acceptedby`, `me`.`accepteddate`, `me`.`rejectedby`, `me`.`rejecteddate`, `me`.`lastmodificationby`, `me`.`lastmodificationdate`, `me`.`STATUS`, `me`.`archived`, `me`.`note`, `me`.`staff_note`, `me`.`author`, `me`.`title`, `me`.`copyrightdate`, `me`.`publishercode`, `me`.`date`, `me`.`volumedesc`, `me`.`publicationyear`, `me`.`place`, `me`.`isbn`, `me`.`biblionumber`, `me`.`reason`, `me`.`patronreason`, `me`.`budgetid`, `me`.`branchcode`, `me`.`collectiontitle`, `me`.`itemtype`, `me`.`quantity`, `me`.`currency`, `me`.`price`, `me`.`total` FROM `suggestions` `me` WHERE ( ( `suggestedby` = '33805' AND `title` = 'suggested' ) )

Maybe a wildcard search might be better here? Or, using Datatables client side, like the staff interface.

Observed on 22.11 and 23.05
Comment 1 Jonathan Druart 2023-06-09 13:22:56 UTC
Looks like a duplicate of bug 27278.

*** This bug has been marked as a duplicate of bug 27278 ***