Hi,

22 juillet 2020 12:12 "Stephen Graham" <[email protected] 
(mailto:[email protected]?to=%22Stephen%20Graham%22%20<[email protected]>)>
 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?
_______________________________________________
Koha-devel mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to