SAP CPI Filter XPath

March 7, 2022

Select all data noodes that are not empty :

1

      <xsl:for-each select="data[ .!='' ]">

To filter records that have a field with a value less or equal than today :

XPath:

    /*[local-name()='RootName' and namespace-uri()='http://namespace']/*[local-name()='RecordName' and namespace-uri()=''] [ xs:date(subrecord/mydate) le xs:date(current-date())]

XSL:

1
2

      <xsl:variable name="today" select="format-date(current-date(), '[Y0001]-[M01]-[D01]')" />
        <xsl:for-each select="s:RecordName[s:subrecord/s:mydate/text() le $today]">

more to come