[Koha-bugs] [Bug 28808] Item search should allow wildcard in subfield when setting up custom search option

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28808

Nick Clemens <nick at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |nick at bywatersolutions.com

--- Comment #1 from Nick Clemens <nick at bywatersolutions.com> ---
Currently the code is something like:
ExtractValue(metadata,'//record/datafield[@tag="XXX"]/subfield[@code="Y"]')
LIKE 'TERM'

If we defaulted to a contains search we could implement as:
SELECT ExtractValue(metadata,'//datafield[@tag="XXX"]/subfield[@code="Y" AND
contains(.,"TERM")]')

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.