[xsl] Filtering source XML with XSL

Subject: [xsl] Filtering source XML with XSL
From: "Chanchlani, Lalit" <lalit.chanchlani@xxxxxxxxxx>
Date: Tue, 30 Oct 2007 11:01:44 +0530
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
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - -

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.

Current Thread