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