XPath (c#) Selecting nodes, then further selecting nodes based on the first query

Question

Hello,

I have the following XML

   <question>
    <questiontext>How old are you?</questiontext>
    <options>
      <option oldScore="0" Score="20">17-25</option>
      <option oldScore="8" Score="12">26-30</option>
      <option oldScore="20" Score="2">31-50</option>
      <option oldScore="16" Score="10">51-60</option>
      <option oldScore="12" Score="14" >61-70</option>
      <option oldScore="8" Score="16" >71+</option>
    </options>
  </question>

What I need to be able to do, is select the exact node based on the question text, and option text.

E.g. return the node that has questiontext = "How old are you?" and option="71+"

questions/question[questiontext='How old are you?']/options[option='71+']/option

The above does work, but it ALWAYS returns the first node, not the node I want.

Help! :)

Thanks guys

Answer 1

Try:

questions/question[questiontext='How old are you?']/options/option[text()='71+']