using xquery to extract attribute value from xml which contains namespaces

Question

I am trying to extract the attribute value of element in the following xml file

<catalog xmlns="http://www.unidata.ucar.edu/namespaces/thredds/InvCatalog/v1.0" xmlns:xlink="http://www.w3.org/1999/xlink" name="TimeSeriesServer THREDDS Catalog">
    <service base="http://tsds.net/tsds/" serviceType="OpenDAP"/>
    <catalogRef xlink:title="local" xlink:href="test/ncml_catalog.thredds"/>
    <catalogRef xlink:title="remote" xlink:href="http://virbo.org/metamag/viewDataFile.jsp?docname=C6D5623A-ADEC-8397-88A7-DD62A37BA490&amp;filetype=data"/>
</catalog>

and the xquery is

declare namespace prefix= "http://www.unidata.ucar.edu/namespaces/thredds/InvCatalog/v1.0";
declare namespace xlink="http://www.w3.org/1999/xlink";

let $xslt:= "/db/virbo/xq/merge/merge.xsl"
let $xml := "/db/virbo/xq/merge/F8ADA960-F16B-5F72-6B09-BE1FE64E5BB1.xml"

return 
   <li>{doc($xml)/prefix:catalog/prefix:catalogRef/@tile}</li>

it suppose to give me test/ncml_catalog.thredds and http://virbo.org/metamag/viewDataFile.jsp?docname=C6D5623A-ADEC-8397-88A7-DD62A37BA490&filetype=data but the last line seems not working and don't know why. Thanks inadvance

is @tile a typo for @title or @href?

evil otto
– evil otto

2011-08-05 17:23:32 +00:00
Commented Aug 5, 2011 at 17:23 — evil otto
– evil otto, Commented Aug 5, 2011 at 17:23

Oliver Hallam · Accepted Answer · 2011-08-05 15:41:14Z

2

Your @title is matching a title attribute in no namespace, yet you are looking for a title element in the xlink namespace. Changing the test to @xlink:title will fix this.

The path is returning an attribute node which is then copied into the li element, which will give a result something like:

<li xlink:title="..." />

Whereas I suspect you actually want the data from the attribute.

Change your last line to

<li>{doc($xml)/prefix:catalog/prefix:catalogRef/@xlink:tile/data(.)}</li>

and everything should work.

answered Aug 5, 2011 at 15:41

Oliver Hallam

4,2621 gold badge28 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

evil otto Over a year ago

alternately, use string() instead of data(): <li>{string(doc($xml)/prefix:catalog/prefix:catalogRef/@xlink:tile)}</li>

Collectives™ on Stack Overflow

using xquery to extract attribute value from xml which contains namespaces

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related