Getting element names using XPath/XQuery

xpath xquery
Lucy picture Lucy · Jun 20, 2012 · Viewed 18.2k times · Source

having the following XML sample document, I need to issue an XPath/XQuery expression to get the element names for every children of a CD element.

<CD>
  <TITLE>Empire Burlesque</TITLE>
  <ARTIST>Bob Dylan</ARTIST>
  <COUNTRY>USA</COUNTRY>
  <COMPANY>Columbia</COMPANY>
  <PRICE>10.90</PRICE>
  <YEAR>1985</YEAR>
</CD>

So I need the query to return TITLE, ARTIST, COUNTRY, COUNTRY, PRICE, YEAR , any one can help please? thanks

Answer

Michael Kay picture Michael Kay · Jun 20, 2012 
/CD/*/name()

(padded out because StackOverflow doesn't like short answers)

Related questions

Concatenate multiple node values in xpath

I have a XML that looks like this <element1> <element2> <element3> <element4>Hello</element4> <element5>World</element5> </element3> <element3> <element4>…

Read More
Is there a JSON equivalent of XQuery/XPath?

When searching for items in complex JSON arrays and hashes, like: [ { "id": 1, "name": "One", "objects": [ { "id": 1, "name": "Response 1", "objects": [ // etc. }] } ] Is there some kind of query language I can used to find an item in [0].objects where id = 3?

Read More
Using XPath, How do I select a node based on its text content and value of an attribute?

Given this XML: <DocText> <WithQuads> <Page pageNumber="3"> <Word> July <Quad> <P1 X="84" Y="711.25" /> <P2 X="102.062" Y="711.25" /> <P3 X="102.062" Y="723.658" /> <P4 X="84.0" Y="723.658" /> &…

Read More