Test of existence on a Table \"Oracle\"

Home Page Forums BizTalk 2004 – BizTalk 2010 Test of existence on a Table \"Oracle\" Test of existence on a Table \"Oracle\"

#12433

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:)