How to create Conditional Xpath statement?

xml xpath selectnodes
patel picture patel · Oct 11, 2011 · Viewed 15.9k times · Source

I want to select xml node with conditional Xpath like-

xmlnode.SelectSingleNode("if (ns:substanceAdministration/ns:consumable/@typeCode == UNK) then evaluateThisXpath else evaluateOtherXpath")

my concern is-

<drugID code="UNK">
    <sub code="2232" />
</drugID>

If @code of parent node is UNK then only it should take @code value of child node otherwise take parent @code value.

Answer

frisco picture frisco · Oct 11, 2011

This should do the trick:

(drugID[@code='UNK']/sub)|(drugID[@code<>'UNK')

It is Xpath pseudocode, change it to your library language

Related questions

Basics of XmlNode.SelectNodes?

I'm not sure why this isn't working. I have an XmlNode in a known-format. It is: <[setting-name]> <dictionary> <[block-of-xml-to-process]/> <[block-of-xml-to-process]/> <[block-of-xml-to-process]/> </dictionary> </[setting-name]> I have a …

Read More
How to use XPath contains() here?

I'm trying to learn XPath. I looked at the other contains() examples around here, but nothing that uses an AND operator. I can't get this to work: //ul[@class='featureList' and contains(li, 'Model')] On: ... <ul class="featureList"> &…

Read More
Select values from XML field in SQL Server 2008

Just looking at my XML field, my rows look like this: <person><firstName>Jon</firstName><lastName>Johnson</lastName></person> <person><firstName>Kathy</firstName&…

Read More