• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

XPATH - selection based on multiple attribute values

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Sheriff
Posts: 26790
82
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
My guess:
 
Nisha Soorya
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That did work exactly the way I wanted. Sorry for being late to say THANK YOU. I was excited when it worked.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic