[Koha-bugs] [Bug 33969] New: Purchase suggestion Search (title filter) only exact match
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Jun 9 13:19:29 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33969
Bug ID: 33969
Summary: Purchase suggestion Search (title filter) only exact
match
Change sponsored?: ---
Product: Koha
Version: 23.05
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Acquisitions
Assignee: koha-bugs at lists.koha-community.org
Reporter: bc at interleaf.ie
QA Contact: testopia at bugs.koha-community.org
Created attachment 152238
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152238&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list