xPath and distinguished fields not working

Dear All,

I have spent a couple days on this problem with no resolution, I just need to retrieve the value of an element in one of my orchestrations, I have done this in other projects in the solution with xpath by doing this and this is what I am doing

CurrentDateString = System.Convert.ToString(xpath(BankRefundCutOffRQ, “string(/*[local-name()=’SADAD’ and namespace-uri()=”]/*[local-name()=’BankSvcRq’ and namespace-uri()=”]/*[local-name()=’BankRefundCutOffRq’ and namespace-uri()=”]/*[local-name()=’PrcDt’ and namespace-uri()=”])”));

I don’t understand why it works in other projects with other messages and not here, I copied the namespace and path from the schema by clicking on the element itself.

I also tried to distinguish the field and call it using (I converted to string because the element is defined as DateTime)

CurrentDateString = System.Convert.ToString(BankRefundCutOffRQ.BankSvcRq.BankRefundCutOffRq.PrcDt);

the funny thing is this call to count the same element which I am trying to retreive returns the correct value (returns 1)

recordCount = System.Convert.ToString(xpath(BankRefundCutOffRQ, “count(/*[local-name()=’SADAD’ and namespace-uri()=”]/*[local-name()=’BankSvcRq’ and namespace-uri()=”]/*[local-name()=’BankRefundCutOffRq’ and namespace-uri()=”]/*[local-name()=’PrcDt’ and namespace-uri()=”])”));

at one point I thought maybe I had a missing assembly reference, I checked the other projects and they reference Microsoft.BizTalk.GlobalPropertySchemas

so I added that to my project with no luck..Please HELP! I can’t believe so much time was wasted on this silly problem

My XML message I am using looks like this

– <SADAD>