SAP CPI:Filter condition in XSLT with date compare

[former_member140163]

Hi,

I am trying to filter the records in SAP CPI if the end_date is ge a date(I am adding the date which is set earlier.It would be in format yyyy-MM-DD) in XSLT.But my condition is failing with conversion errors.

This is what I am trying to use:

<?xml version="1.0" encoding="UTF-8" ?>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xsl:output method="xml" omit-xml-declaration="yes" encoding="UTF-8" indent="yes" />

<xsl:param name="lastrun" select='2021-09-15'/>

<xsl:template match="/"> <Root>

<xsl:for-each select="/CompoundEmployee"> <xsl:if test="xs:date(person/employment_information[1]/end_date) ge xs:date('$lastrun')">

I am getting a error Invalid date "$lastrun" (Non-numeric year component).

I tried a lot of ways but not able to achieve this.

Any help is appreciated.

[madhukar_mutyampalli]

Hi,

Have you tried using the normal filter option available ?

/CompoundEmployee/CompoundEmployee[(person/employment_information/end_date >= $lastrun)]

or

if you are using sucessfactor adapter you will have filter option in the processing tab-> Query editor. can you try it.

[former_member140163]

Hi Madhukar,

I have a couple of other filter criterias along with this.So I am trying to filter in XSLT

[MortenWittrock]

Hi Shruthi

So how did it work out?

Regards,

Morten

[former_member140163]

Hi Morten,

I was referring a parameter in the XSLT and passed the date value in single quotes. So it was being treated as a different data type.Then after research I found the xsl:param value has to be passed in single quotes between the double quotes.Then it worked.

[MortenWittrock]

Hi Shruthi

$lastrun should not be in single quotes. With the quotes, you are passing the literal string "$lastrun" to the xs:date function. So it's not getting the contents of the property lastrun, which is what you want. Remove the quotes, and you are good to go.

I've written a blog post about filtering XML elements, which you can check out for further inspiration.

Regards,

Morten