xsl-list
[Top] [All Lists]

Re: [xsl] Filtering source XML with XSL

2007-10-30 03:44:44
as Joe said, I suspect you are not setting the parameter while
starting the transformation.

For e.g. with Xalan-J you have to invoke the transformation like following:

java org.apache.xalan.xslt.Process -in test.xml -xsl test.xsl -PARAM
ExternalRefId value

On 10/30/07, Chanchlani, Lalit <lalit(_dot_)chanchlani(_at_)lehman(_dot_)com> 
wrote:
Hi Mukul,

I tried with the XSL you provided. But I am getting the output as:

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

I have also put the value of ExternalRefId. Can you please help?

Regards,
Lalit

-----Original Message-----
From: Mukul Gandhi [mailto:gandhi(_dot_)mukul(_at_)gmail(_dot_)com]
Sent: Tuesday, October 30, 2007 2:23 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Filtering source XML with XSL

Hope this helps

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
version="1.0">

 <xsl:output method="xml" indent="yes" />

 <xsl:param name="ExternalRefId" />

 <xsl:template match="/">
   <result>
     <xsl:copy-of select="Trades/Trade[Header/ExternalRefId =
$ExternalRefId]" />
   </result>
 </xsl:template>

</xsl:stylesheet>

On 10/30/07, Chanchlani, Lalit <lalit(_dot_)chanchlani(_at_)lehman(_dot_)com> 
wrote:
Hi All,

I have got the below source XML. I need to copy the source XML to the
output tree based on a parameter. The parameter will be the value of
the field ExternalRefId. So basically the contents of the specific
<Trade> </Trade> matching its ExternalRefId should be selected to the
output.

Can someone please advise how can I write a XSL for performing the
above?


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

<Trades>
 <Trade Type="DefaultSwap">
   <Header>
     <OriginatingSystem>XXX</OriginatingSystem>
     <ExternalRefId>SPZ3027V2</ExternalRefId>
     <ActionType>New</ActionType>
     <SentOn>20071022 10:25</SentOn>
     <Workflow>YES</Workflow>
     <SenderId>xxxxx</SenderId>
   </Header>
   <ReferenceObligation>
     <SecurityCurrency>XXX</SecurityCurrency>
     <Ticker>XXX</Ticker>
     <CusipOrIS>XXX</CusipOrIS>
     <SecurityId>XXDD</SecurityId>
     <SecurityDesc>DDDDD</SecurityDesc>
     <Issuer>ITV PLC</Issuer>
     <OriginalFace>325000000.0</OriginalFace>
     <RateType>FIXED</RateType>
     <Coupon>5.375</Coupon>
     <SecurityMaturity>20151019</SecurityMaturity>
     <SecurityPurpose>BOOKING ONLY</SecurityPurpose>
     <IssueDate>20051019</IssueDate>
     <FirstCouponDate>20061019</FirstCouponDate>
     <LastCouponDate>20141019</LastCouponDate>
     <IssuerCountry>GB</IssuerCountry>
     <ReferenceEntityId>GKDHCEAC8</ReferenceEntityId>
   </ReferenceObligation>
   <BookingInfo>
     <Books>
       <Book>
         <BookName>NODCCDS</BookName>
         <BookingSystem>CDS</BookingSystem>
         <BookingDesk>44446</BookingDesk>
       </Book>
     </Books>
     <FlowFlag>Easy</FlowFlag>
     <LegRole>All</LegRole>
   </BookingInfo>
 </Trade>
 <Trade Type="DefaultSwap">
   <Header>
     <OriginatingSystem>YYY</OriginatingSystem>
     <ExternalRefId>SPZ3027U4</ExternalRefId>
     <ActionType>New</ActionType>
     <SentOn>20071022 10:25</SentOn>
     <Workflow>YES</Workflow>
     <SenderId>xxx</SenderId>
   </Header>
   <ReferenceObligation>
     <SecurityCurrency>GBP</SecurityCurrency>
     <Ticker>ITV</Ticker>
     <CusipOrISIN>RED</CusipOrISIN>
     <SecurityId>XS0232037233</SecurityId>
     <SecurityDesc>ITVLN 5 3/8 10/19/15</SecurityDesc>
     <Issuer>ITV PLC</Issuer>
     <OriginalFace>325000000.0</OriginalFace>
     <RateType>FIXED</RateType>
     <Coupon>5.375</Coupon>
     <SecurityMaturity>20151019</SecurityMaturity>
     <SecurityPurpose>BOOKING ONLY</SecurityPurpose>
     <IssueDate>20051019</IssueDate>
     <FirstCouponDate>20061019</FirstCouponDate>
     <LastCouponDate>20141019</LastCouponDate>
     <IssuerCountry>GB</IssuerCountry>
     <ReferenceEntityId>GKDHCEAC8</ReferenceEntityId>
   </ReferenceObligation>
   <PaymentBusinessCenters>
     <PaymentBusinessCenter1>London</PaymentBusinessCenter1>
     <PaymentBusinessCenter2>New York</PaymentBusinessCenter2>
   </PaymentBusinessCenters>
 </Trade>
</Trades>

Regards,
Lalit


--
Regards,
Mukul Gandhi



-- 
Regards,
Mukul Gandhi

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>