Hi Graham,
You are using ">=" in the subfield construct. If you want just the
subfield u as URL you should just use "=". Similarly in the other
ExtractValue constructs.
All the best.
Ian
On 22/07/2020 08:20, Stephen Graham wrote:
(sorry if you have received this twice, my email client crashed when I sent
yesterday - and not sure if it actually sent)
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: [email protected]<mailto:[email protected]>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
--
Ian Bays
Director, PTFS Europe Limited
Content Management and Library Solutions
+44 (0) 7774 995297 (mobile)
skype: ian.bays
email: [email protected]
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
