Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Test of existence on a Table \"Oracle\" › Test of existence on a Table \"Oracle\"
Hi Achille,
please be aware that Stephen’s xpath will find RECORD’s everywhere in your document. This might be what you need, but that \”Operation1\”-Tag bothers me a bit. What if there is another operation with some other records? You would count them, too.
So it really all depends on the possible structure of the XML-File. An alternative approach, that uses a direct path to your data but avoids the namespace-issue, would be just to use local-name() and ignore the namespaces altogether, like:
/*[local-name()=’patient_omnisResponse’]/*[local-name()=’Operation1′]/*[local-name()=’PATIENT_OMNIS’ ]/*[local-name()=’Select’]/*[local-name()=’Record’]
TToni
Disclaimer: By no means I want to diminish the value of Stephen’s advice (I might need it very soon, too :wink:)