ashridharan
Technical User
Hi
I have an XML document which looks like
<ROOT>
<PARENT Id="1">
<SOMENODE>ABC</SOMENODE>
<SOMENODE>123</SOMENODE>
<SOMENODE>XYZ</SOMENODE>
</PARENT>
<PARENT Id="2">
<SOMENODE>123</SOMENODE>
</PARENT>
</ROOT>
As can be seen, there are multiple instances of "SOMENODE". the condition i want to execute is to return all "PARENT" ids which has no instance of "SOMENODE = 123"
However, the XML parser (MSXML as well as .NET) takes each node as an individual node and does not group them. This returns node 1 in the result set. This is however the wrong result as neither of the PARENT nodes satisfy this clause.
Does anyone have any clues about how to solve this ?
thanks in advance
I have an XML document which looks like
<ROOT>
<PARENT Id="1">
<SOMENODE>ABC</SOMENODE>
<SOMENODE>123</SOMENODE>
<SOMENODE>XYZ</SOMENODE>
</PARENT>
<PARENT Id="2">
<SOMENODE>123</SOMENODE>
</PARENT>
</ROOT>
As can be seen, there are multiple instances of "SOMENODE". the condition i want to execute is to return all "PARENT" ids which has no instance of "SOMENODE = 123"
However, the XML parser (MSXML as well as .NET) takes each node as an individual node and does not group them. This returns node 1 in the result set. This is however the wrong result as neither of the PARENT nodes satisfy this clause.
Does anyone have any clues about how to solve this ?
thanks in advance