Ravindar, Biztalk Developer and Administrator

Just another BizTalk blog

Multilevel xpath filtering

when you want to do multilevel filtering, make sure you embed the multilevel element structure in brackets inside the filter box []

 

/*[local-name()=’BankPartyProductChangedEvent’ and namespace-uri()=’test’]/*[local-name()=’DataArea’ and namespace-uri()=’test’]/*[local-name()=’CommonData’ and namespace-uri()=’test’]/*[local-name()=’LocationList’ and namespace-uri()=’test’]/*[local-name()=’Location’ and namespace-uri()=’test’][(*[local-name()=’AddressReference’]/@*[local-name()=’referenceKey’])=’1′]/@*[local-name()=’key’ and namespace-uri()=”]

 

May 25, 2017 Posted by | Uncategorized | Leave a comment

Concatenate repeating node with a delimiter

<xsl:element name="ns0:Dummy">
     <xsl:for-each select="/s0:BankPartyProductChangedEvent/s0:DataArea/s0:PartyList/s0:Party/s0:DataProtectionList/s0:DataProtection">
         <xsl:if test="position()>1">
             <xsl:value-of select="','"/>
         </xsl:if>
         <xsl:value-of select="s0:DataTypeCode/text()"/>
      </xsl:for-each>
<xsl:element>

May 23, 2017 Posted by | Uncategorized | Leave a comment