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? Cheers, Stephen PS we are on 19.11. -------------------------------------- Stephen Graham Library Technology Consultant Content and Collections Team Library and Computing Services University of Hertfordshire Tel: 01707 286111 Ext: 77751 Email: s.graham4@herts.ac.uk<mailto:s.graham4@herts.ac.uk>
Hi, 22 juillet 2020 12:12 "Stephen Graham" <s.graham4@herts.ac.uk (mailto:s.graham4@herts.ac.uk?to=%22Stephen%20Graham%22%20<s.graham4@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?
participants (2)
-
Didier Gautheron -
Stephen Graham