Subject: Re: Filtering source XML with XSL
From: "Mukul Gandhi" <gandhi.mukul@xxxxxxxxx>
Date: Tue, 30 Oct 2007 14:22:59 +0530
|
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.chanchlani@xxxxxxxxxx> 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
|