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

FW: Filtering xml output

Subject: FW: Filtering xml output
From: "Campbell, Peter" <peter.campbell@xxxxxxxxxxxxxxxx>
Date: Mon, 18 Dec 2006 14:56:47 -0000
 FW: Filtering xml output
I am new to using xslt  and have hit a bit of a rut.
 
I am receiving the
following xml via SOAP, and I want to filter out all
the
<CollectionStructure> Elements that have PESTCRTL2 in the
<Reference> node.
The Output will be xml.
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:HNS="http://tempuri.org/">
    <SOAP-ENV:Header>
<HNS:ROClientID>{****************************************}</HNS:ROClient
ID>
</SOAP-ENV:Header>
    <SOAP-ENV:Body xmlns:ro="urn:RefuseLibrary">
<NS1:GetCollectionDetailsByUniquePropertyReferenceNumberResponse
xmlns:NS1="RefuseService">
            <Result>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-19T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Tuesday</DayOfWeek>
                    <RoundID>000305</RoundID>
<Reference>PESTCTRL2</Reference>
                    <Description>Pest
Control Area 2</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>99</MaxJobs>
<JobCount>0</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-20T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Wednesday</DayOfWeek>
<RoundID>000345</RoundID>
                    <Reference>DAWED</Reference>
<Description>Domestic Appliances
Wednesday</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>33</MaxJobs>
<JobCount>7</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-20T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Wednesday</DayOfWeek>
<RoundID>000307</RoundID>
<Reference>PESTCTRL2</Reference>
                    <Description>Pest
Control Area 2</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>99</MaxJobs>
<JobCount>0</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-21T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Thursday</DayOfWeek>
                    <RoundID>000309</RoundID>
<Reference>PESTCTRL2</Reference>
                    <Description>Pest
Control Area 2</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>99</MaxJobs>
<JobCount>0</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-22T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Friday</DayOfWeek>
                    <RoundID>000311</RoundID>
<Reference>PESTCTRL2</Reference>
                    <Description>Pest
Control Area 2</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>99</MaxJobs>
<JobCount>0</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-22T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Friday</DayOfWeek>
                    <RoundID>000346</RoundID>
<Reference>BULKFRI</Reference>
                    <Description>Bulky
Collections Friday</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>18</MaxJobs>
<JobCount>0</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-25T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Monday</DayOfWeek>
                    <RoundID>000314</RoundID>
<Reference>PESTCTRL2</Reference>
                    <Description>Pest
Control Area 2</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>99</MaxJobs>
<JobCount>0</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-26T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Tuesday</DayOfWeek>
                    <RoundID>000316</RoundID>
<Reference>PESTCTRL2</Reference>
                    <Description>Pest
Control Area 2</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>99</MaxJobs>
<JobCount>0</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-27T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Wednesday</DayOfWeek>
<RoundID>000347</RoundID>
                    <Reference>DAWED</Reference>
<Description>Domestic Appliances
Wednesday</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>33</MaxJobs>
<JobCount>2</JobCount>
                </CollectionStructure>
<CollectionStructure>
                    <RoundType>SP</RoundType>
<Date>2006-12-27T00:00:00</Date>
                    <Gang></Gang>
<DayOfWeek>Wednesday</DayOfWeek>
<RoundID>000318</RoundID>
<Reference>PESTCTRL2</Reference>
                    <Description>Pest
Control Area 2</Description>
<TimeOfDayDescription></TimeOfDayDescription>
<BackOfficeNotes></BackOfficeNotes>
                    <MaxJobs>99</MaxJobs>
<JobCount>0</JobCount>
                </CollectionStructure>
</Result>
</NS1:GetCollectionDetailsByUniquePropertyReferenceNumberResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope> 

Thank you for your help
 
Peter
Campbell
CRM Business Analyst
Customer Services
Allerdale BC
 
To view
the latest Allerdale information visit  www.allerdale.gov.uk
*********************************************************************
The
views expressed in this document are those of the individual and
are not
necessarily the same as the Council's.

This electronic transmission is only
intended for the individual or
entity to which it is addressed and may
contain information that is
privileged, confidential and exempt from
disclosure. If you are not
the intended recipient or employee or agents
responsible for
delivering the message to the intended recipient you are
hereby
notified that any dissemination, distribution or copying of this
communication and its attachments is strictly prohibited. If you
have
received this communication in error please notify us by
telephone and return
the original communication and attachments to 
us at the e-mail address
above.

This footnote also confirms that this email message has been swept
for the presence of computer viruses.
**********************************************************************

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.