Im trying to get the parent node based of child element value
I want to do something like that get TransactionDetail element where SequenceNumber = 2
I tried to do it like that but im missing something...
ancestor:://*[local-name()='SequenceNumber'][text()=2]
//TransactionDetail[//SequenceNumber = 2]
this is the xml
<Root>
<biztalk_1>
<body>
<ActiveStore_SalesTransaction_1.70>
<TransactionDetail>
<SequenceNumber>2</SequenceNumber>
<TransactionDetailGroup>
<Item>
<ItemID>22</ItemID>
<NonMerchandiseFlag>1</NonMerchandiseFlag>
</Item>
</TransactionDetailGroup>
</TransactionDetail>
</ActiveStore_SalesTransaction_1.70>
</body>
</biztalk_1>