Xpath path help

Question

I have the following XML:

<products>
    <product>       
        <name>Flat Panel Monitor</name>
        <code>LS123</code>
        <attributes>
            <attribute>
                <group>Color</group>
                <values>
                    <value>Red</value>
                    <value>Blue</value>
                    <value>Green</value>
                </values>
            </attribute>
            <attribute>
                <group>Warranty</group>
                <values>
                    <value>5 Year</value>
                </values>
            </attribute>
        </attributes>
    </product>
</products>

What Xpath would i use to get all value's with the attribute node with the group node value of "Color" ? A standard Xpath of /product/attributes/attribute/values/value would return all value's including value's from within the Warranty group but i need to keep them separate.

I guess in pseudocode what i'm saying is get all "value" where the parent node "values" is a sibling of the node "group" with the value "Color" - hopefully this is possible?

Thanks.

Answer 1

You need to use square brackets to filter the nodes, thus: /product/attributes/attribute[group='Color']/values/value

Answer 2

You require only those value nodes that have a group 'uncle' of Color, so put that as a condition on the xpath you have already worked out:

/product/attributes/attribute/values/value[../../group = 'Color']

This says that for a value node to be valid, it must have a parent with a parent with a child with value Color.

Answer 3

//values[preceding-sibling::group[text()="Color"]]/value

Answer 4

Yet another option:

//value[ancestor::attribute[group='Color']]