RE: [xsl] Filtering source XML with XSL

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

--~------------------------------------------------------------------
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>
--~--

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
- - - -

This message is intended only for the personal and confidential use of the 
designated recipient(s) named above.  If you are not the intended recipient of 
this message you are hereby notified that any review, dissemination, 
distribution or copying of this message is strictly prohibited.  This 
communication is for information purposes only and should not be regarded as an 
offer to sell or as a solicitation of an offer to buy any financial product, an 
official confirmation of any transaction, or as an official statement of Lehman 
Brothers.  Email transmission cannot be guaranteed to be secure or error-free.  
Therefore, we do not represent that this information is complete or accurate 
and it should not be relied upon as such.  All information is subject to change 
without notice.


--~------------------------------------------------------------------
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>
--~--