[Koha-bugs] [Bug 20689] Make it possible to add capital letter subfields to item search fields

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

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

--- Comment #39 from Nick Clemens <nick at bywatersolutions.com> ---
The problem seems to be in ExtractValue:

SELECT 
    ExtractValue(metadata,
'//record/datafield[@tag="520"]/subfield[@code="A"]')
FROM biblio_metadata 
WHERE 
    ExtractValue(metadata,
'//record/datafield[@tag="520"]/subfield[@code="A"]') !="";

This returns both 'A' and 'a' subfields

We need to figure a method to make the query case sensitive

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