[Koha-devel] 855 Field and SQL Query

[Didier Gautheron]

Hi,

22 juillet 2020 12:12 "Stephen Graham" <s.graham4 at herts.ac.uk (mailto:s.graham4 at herts.ac.uk?to=%22Stephen%20Graham%22%20<s.graham4 at herts.ac.uk>)> a écrit:
	Hi All – when I try and pull out subfield $u of the 856 field I always get the public note as well (i.e. $z). An example of the query I’m running: 

	select  

	biblionumber, 

	ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code>="a"]') AS title, 

	ExtractValue(metadata,'//datafield[@tag="856"]/subfield[@code>="u"]') as URL 

	from  

	biblio_metadata  

	where  

	ExtractValue(metadata,'//datafield[@tag="856"]/subfield[@code>="u"]') like '%dawsonera.com%'; 

	This is correct isn’t it? I haven’t requested $z, so not sure why it is always in the results? Feature? Bug? Or me doing something wrong? Did you try with

[@code="u"]') ie not >= but equality?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20200722/1ae3b416/attachment.htm>