96

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?

pevik
  • 4,523
  • 3
  • 33
  • 44
Flavius
  • 13,566
  • 13
  • 80
  • 126

3 Answers3

110

Found it:

/records/record/name[../record-type/text() = "A"]
Flavius
  • 13,566
  • 13
  • 80
  • 126
  • 10
    It's [simpler and clearer](http://stackoverflow.com/a/31118801/290085) to test `record` before descending to `name`. – kjhughes Jun 29 '15 at 19:54
66

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.

kjhughes
  • 106,133
  • 27
  • 181
  • 240
38

You can also filter a parent element by its children :

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

thomasb
  • 5,816
  • 10
  • 57
  • 92
  • 6
    It's [simpler and clearer](http://stackoverflow.com/a/31118801/290085) to test `record-type` directly without an additional predicate. – kjhughes Jun 29 '15 at 19:55