XPATH - selection based on multiple attribute values

[Nisha Soorya]

Hello Experts,

I'm stuck with trying to construct an Xpath expression. I have an xml document resembling the following:

<root>
<record id="1">
<field id="220" value="Red" />
<field id="221" value="Small" />
<field id="222" value="25" />
</record>
<record id="2">
<field id="220" value="Red" />
<field id="221" value="Large" />
<field id="222" value="50" />
</record>
</root>

I want to return the record where the value of the field with id=220 is "Red" AND where the value of the field with id="221" is "Large".

In other words, I want to find a parent node based on the attributes of 2 of its element children.

Can you help?

Nisha

[Paul Clapham]

My guess:

record[field[@id='220' and @value='Red'] and field[@id='221' and @value='Large']]

[Nisha Soorya]

That did work exactly the way I wanted. Sorry for being late to say THANK YOU. I was excited when it worked.