How to select parent based on a child value via XPath?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Art - 29 Aug 2007 19:38 GMT

Here is sample XML:

<Root>
<A>
<B>
<C>Yes</C>
</B>
</A>
:
<A>
<B>
<C>No</C>
</B>
</A>
</Root>

There can be any # of nested <A> with values of either Yes or No. I would
like to select <A> node(s) based on value of <C>. In pseudo code:

Give me all <A> where <C> = "Yes" (or "No). So far I was able to select all
"Yes" (or "No") but these are <C> nodes and need their grandparents.
TIA

Reply to this Message

Peter Flynn - 29 Aug 2007 23:25 GMT

> Here is sample XML:
>
[quoted text clipped - 17 lines]
> Give me all <A> where <C> = "Yes" (or "No). So far I was able to select all
> "Yes" (or "No") but these are <C> nodes and need their grandparents.

In XPath, //A[descendant::C='Yes'] or possibly //C[.='Yes']/ancestor::A

///Peter

Signature

XML FAQ: http://xml.silmaril.ie/

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...