Cart
[Home] [By Thread] [By Date] [Recent Entries]
Hi martin,
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. Please suggest me on best of way of doing this. Thanks, Anil
|
