XPath not working with SelectSingleNode

Question

private const string TECHACCOUNTAMTITEM_AMT_XPATH = @"//Part[translate(@Type, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') = 'instalment']/acord:Jv-Ins-Reinsurance/acord:TechAccount/acord:Subaccount/acord:TechAccountAmtItem[translate(@Type, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') != 'ipt' and translate(@AmtStatus, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') != 'informational']/acord:Amt";

var xmlNamespaceManager = this._namespaceManager.GetNamespaceManager(this.TransactionPayload.OuterXml);
                var techAccountAmtItemAmt = Decimal.Parse(this.TransactionPayload.SelectSingleNode(TECHACCOUNTAMTITEM_AMT_XPATH, xmlNamespaceManager).InnerText);

The above two statement gives out the value 4500.

But i dont want to use translate and just want to use it directly to fetech the value .

It seems that != is not working in the below and not fetching the value and resulting in null .

Here is the new Xpath i m trying to achieve but not working .

private const string TECHACCOUNTAMTITEM_AMT_XPATH = @"//Part[@Type = 'Instalment']/acord:Jv-Ins-Reinsurance/acord:TechAccount/acord:Subaccount/acord:TechAccountAmtItem[@Type != 'ipt' and @AmtStatus != 'informational']/acord:Amt";

How can I acheive the same ?

Daniel Hilgarth · Accepted Answer · 2017-12-27 10:40:51Z

2

The reason for this is that != requires the attribute to exist, while translate will also produce a result if the attribute is missing.

You need to use not() instead:

.../acord:‌TechAccountAmtItem[not(@‌Type = 'ipt') and not(@AmtStatus = 'informational')]/...

This assumes that Type could be missing as well. If not, you can use @Type != 'ipt' instead.

edited Dec 27, 2017 at 10:40

answered Dec 21, 2017 at 13:24

Daniel Hilgarth

175k41 gold badges346 silver badges450 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RahulJha Over a year ago

I have tried [not() and not()] and so many keywords from MSDN but didn't work for hours. I gave it a try this time and it worked like charm. Thanks :) [not(@Type = 'insurance_premium_tax') and not(@AmtStatus = 'informational')]

Collectives™ on Stack Overflow

XPath not working with SelectSingleNode

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related