[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Filtering source XML with XSL

Subject: RE: Filtering source XML with XSL
From: "Joe Fawcett" <joefawcett@xxxxxxxxxxx>
Date: Tue, 30 Oct 2007 10:55:55 +0000
RE:  Filtering source XML with XSL
The carriage return looks suspicious. Try this one:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">

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

<xsl:param name="ExternalRefId" select="'SPZ3027V2'"/>

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

</xsl:stylesheet>

If that works then there's a problem with setting the parameter. What environment are you using and how are you setting it?

Joe


From: "Chanchlani, Lalit" <lalit.chanchlani@xxxxxxxxxx>
Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE:  Filtering source XML with XSL
Date: Tue, 30 Oct 2007 16:10:16 +0530

Following is the result I get after setting the param value.

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

Also, there is no DTD reference / namespace declarations for the XML.

Regards,
Lalit


-----Original Message----- From: Joe Fawcett [mailto:joefawcett@xxxxxxxxxxx] Sent: Tuesday, October 30, 2007 3:59 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: RE: Filtering source XML with XSL

Are you sure you set the param ExternalRefId? Suggest you add
<xsl:value-of select="$ExternalRefId" /> just after the <result> tag.

Are you sure you haven't simplified the example by removing namespace
declarations or a DTD reference?

Joe
http://joe.fawcett.name


>From: "Chanchlani, Lalit" <lalit.chanchlani@xxxxxxxxxx> >Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx >To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> >Subject: RE: Filtering source XML with XSL >Date: Tue, 30 Oct 2007 15:52:00 +0530 > >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.mukul@xxxxxxxxx] >Sent: Tuesday, October 30, 2007 2:23 PM >To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx >Subject: Re: 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.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 > >- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

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

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

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.