[Bug 28808] New: Item search should allow wildcard in subfield when setting up custom search option
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28808 Bug ID: 28808 Summary: Item search should allow wildcard in subfield when setting up custom search option Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Searching Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org When querying a MARC record via SQL directly, one can wildcard the subfield to search an entire MARC tag -- like "ExtractValue(metadata,'//datafield[@tag="650"]/*')" to look at the whole 650 without specifying a subfield. It would be nice to be able to select "*" for one's subfield when setting up a custom item search field. As is, you have to either leave it blank (which will break all searches) or pick a specific value. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28808 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nick@bywatersolutions.com --- Comment #1 from Nick Clemens <nick@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.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org