Hello Experts,
In my scenario ,I have the following XML input file (in a very shortened form):

When replicating employees with multiple records of "PersonalDetails, the mapping works intermittently.
How can I keep only the personal_information record where end_date > =current date ?
I have applied the below standard function :


Filter und XSLT mapping :
/queryCompoundEmployeeResponse/CompoundEmployee [xs:date(person/personal_information/end_date) ge xs:date(current-date())]
?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="3.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xsl:mode on-no-match="shallow-copy" /> <xsl:template match="/queryCompoundEmployeeResponse/CompoundEmployee[xs:date(person/personal_information/end_date) ge current-date()]"/> </xsl:stylesheet> <br>
But this is not woking for me.Please let me know how can resolve this issue ?(Using XSLT mapping or Custum Function...)
Regards,
Fathi