Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Matching a node based on a sibling's value with XPath

Tags:

xml

xpath

Having a XML document like this:

<?xml version="1.0" encoding="UTF-8"?>
<records type="array">
  <record>
    <name>svn</name>
    <record-type>A</record-type>
    <ttl type="integer">86400</ttl>
    <zone-id type="integer">69075</zone-id>
    <aux type="integer">0</aux>
    <id type="integer">xxx</id>
    <active>Y</active>
    <data>xxx.xxx.xxx.xxx</data>
  </record>
  <record>
    <name>domain.tld.</name>
    <record-type>NS</record-type>
    <ttl type="integer">86400</ttl>
    <zone-id type="integer">xxx</zone-id>
    <aux type="integer">0</aux>
    <id type="integer">xxx</id>
    <active>Y</active>
    <data>domain.tld.</data>
  </record>
  <record>
    <name>blog</name>
    <record-type>A</record-type>
    <ttl type="integer">86400</ttl>
    <zone-id type="integer">xxx</zone-id>
    <aux type="integer">0</aux>
    <id type="integer">xxx</id>
    <active>Y</active>
    <data>xxx.xxx.xxx.xxx</data>
  </record>
</records>

How to match all the /records/record/name having as sibling /records/record/record-type with the value A?

like image 287
Flavius Avatar asked May 26 '09 19:05

Flavius


People also ask

How does XPath select sibling elements?

Select all A sibling elements that precede the context node. > Select all A sibling elements that follow the context node. > Select all sibling elements that precede the context node. > Select the first preceding sibling element named A in reverse document order.

How do I navigate to parent node in XPath?

A Parent of a context node is selected Flat element. A string of elements is normally separated by a slash in an XPath statement. You can pick the parent element by inserting two periods “..” where an element would typically be. The parent of the element to the left of the double period will be selected.


3 Answers

Found it:

/records/record/name[../record-type/text() = "A"]
like image 153
2 revs, 2 users 67% Avatar answered Oct 04 '22 04:10

2 revs, 2 users 67%


Surprisingly, none of the answers to date on this old question provide the simplest XPath solution.

This simple XPath

/records/record[record-type = "A"]/name

selects

<name>svn</name>
<name>blog</name>

as requested.

like image 36
kjhughes Avatar answered Oct 03 '22 04:10

kjhughes


You can also filter a parent element by its children :

/records/record[record-type[text()='A']]/name

like image 26
thomasb Avatar answered Oct 03 '22 04:10

thomasb