CODEWITHSUNDEEP
xmlxpath
Flavius
Flavius

Reputation: 13816

Matching a node based on a sibling's value with 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?

Upvotes: 97

Views: 51990

Answers (3)

kjhughes
kjhughes

Reputation: 111491

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.

Upvotes: 69

thomasb
thomasb

Reputation: 6037

You can also filter a parent element by its children :

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

Upvotes: 38

Flavius
Flavius

Reputation: 13816

Found it:

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

Upvotes: 112

Related Questions