<!DOCTYPE html><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head><body><div data-html-editor-font-wrapper="true" style="font-family: arial, sans-serif; font-size: 13px;"> <br>Hi,<br><br>22 juillet 2020 12:12 "Stephen Graham" <<a target="_blank" tabindex="-1" href="mailto:s.graham4@herts.ac.uk?to=%22Stephen%20Graham%22%20<s.graham4@herts.ac.uk>">s.graham4@herts.ac.uk</a>> a écrit:<br> <blockquote><div><div vlink="#954F72" lang="EN-GB"><div> <p>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:</p> <p style="text-autospace: none"><span style='font-size: 10.0pt;font-family: "Courier New";color: blue'>select</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'> </span></p> <p style="text-autospace: none"><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>biblionumber,</span></p> <p style="text-autospace: none"><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>ExtractValue(metadata,</span><span style='font-size: 10.0pt;font-family: "Courier New";color: red'>'//datafield[@tag="245"]/subfield[@code>="a"]'</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>) </span><span style='font-size: 10.0pt;font-family: "Courier New";color: blue'>AS</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'> title,</span></p> <p style="text-autospace: none"><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>ExtractValue(metadata,</span><span style='font-size: 10.0pt;font-family: "Courier New";color: red'>'//datafield[@tag="856"]/subfield[@code>="u"]'</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>) </span><span style='font-size: 10.0pt;font-family: "Courier New";color: blue'>as</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'> URL</span></p> <p style="text-autospace: none"><span style='font-size: 10.0pt;font-family: "Courier New";color: blue'>from</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'> </span></p> <p style="text-autospace: none"><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>biblio_metadata </span></p> <p style="text-autospace: none"><span style='font-size: 10.0pt;font-family: "Courier New";color: blue'>where</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'> </span></p> <p><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>ExtractValue(metadata,</span><span style='font-size: 10.0pt;font-family: "Courier New";color: red'>'//datafield[@tag="856"]/subfield[@code>="u"]'</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>) </span><span style='font-size: 10.0pt;font-family: "Courier New";color: blue'>like</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'> </span><span style='font-size: 10.0pt;font-family: "Courier New";color: red'>'%dawsonera.com%'</span><span style='font-size: 10.0pt;font-family: "Courier New";color: gray'>;</span></p> <p>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?</p> </div></div></div></blockquote>Did you try with<br><br><span style='font-size: 10.0pt;font-family: "Courier New";color: red'>[@code="u"]'</span><span style='font-size: 10.0pt;font-family: "Courier New";color: black'>) ie not >= but equality?<br> </span><br><signature></signature> </div></body></html>