[xsl] FW: Filtering xml output

Subject: [xsl] FW: Filtering xml output
From: "Campbell, Peter" <peter.campbell@xxxxxxxxxxxxxxxx>
Date: Mon, 18 Dec 2006 14:56:47 -0000
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