Subject: Re: [xsl] Break functionality in XSL From: Martin Honnen <Martin.Honnen@xxxxxx> Date: Mon, 02 Nov 2009 18:00:57 +0100 |
this is my sample xml file. <TABLE NAME="PS_JOBCODE_TBL"> <ROWS> <ROW> <COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN> <COLUMN NAME="JOBCODE"><![CDATA[P10]]></COLUMN> <COLUMN NAME="EFFDT"><![CDATA[01-Jan-1996 00:00:00]]></COLUMN> <COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN> <COLUMN NAME="DESCR"><![CDATA[yyyyyyyyyyyyyyy]]></COLUMN> </ROW> <ROW> <COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN> <COLUMN NAME="JOBCODE"><![CDATA[B64]]></COLUMN> <COLUMN NAME="EFFDT"><![CDATA[01-Jan-1900 00:00:00]]></COLUMN> <COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN> <COLUMN NAME="DESCR"><![CDATA[CONSTR SUPR]]></COLUMN> </ROW> <ROW> <COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN> <COLUMN NAME="JOBCODE"><![CDATA[B64]]></COLUMN> <COLUMN NAME="EFFDT"><![CDATA[01-Jun-1966 00:00:00]]></COLUMN> <COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN> <COLUMN NAME="DESCR"><![CDATA[CONSTR SUPR]]></COLUMN> </ROW> <ROW> <COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN> <COLUMN NAME="JOBCODE"><![CDATA[P10]]></COLUMN> <COLUMN NAME="EFFDT"><![CDATA[16-Jul-1991 00:00:00]]></COLUMN> <COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN> <COLUMN NAME="DESCR"><![CDATA[CABLE SPLICERS]]></COLUMN> </ROW> <ROW> <COLUMN NAME="SETID"><![CDATA[COMMN]]></COLUMN> <COLUMN NAME="JOBCODE"><![CDATA[P10]]></COLUMN> <COLUMN NAME="EFFDT"><![CDATA[16-Jul-1994 00:00:00]]></COLUMN> <COLUMN NAME="EFF_STATUS"><![CDATA[A]]></COLUMN> <COLUMN NAME="DESCR"><![CDATA[XXXXXXXXXXX]]></COLUMN> </ROW> </ROWS> </TABLE>
I need to find out the DESCR. based on JobCode
*Input : *Jobcode like P10
*Process: *find out the all the nodes with Jobcode *P10* and find the latest Effective date (EFFDT) and display corresponding DESCR
*output: *DESCR with latest Effective date.
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:data="http://example.com/2009/data" exclude-result-prefixes="data" version="1.0">
<data:data xmlns=""> <month key="Jan" value="01"/> <month key="Feb" value="02"/> <month key="Mar" value="03"/> <month key="Apr" value="04"/> <month key="May" value="05"/> <month key="Jun" value="06"/> <month key="Jul" value="07"/> <month key="Aug" value="08"/> <month key="Sep" value="09"/> <month key="Oct" value="10"/> <month key="Nov" value="11"/> <month key="Dec" value="12"/> </data:data>
Martin Honnen http://msmvps.com/blogs/martin_honnen/
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Break functionality in XSL, Anil Kumar Veeramall | Thread | Re: [xsl] Break functionality in X, Anil Kumar Veeramall |
[xsl] Break functionality in XSL, Anil Kumar Veeramall | Date | [xsl] Question about variable assig, Bill French |
Month |