xsl-list
[Top] [All Lists]

[xsl] FW: Filtering xml output

2006-12-18 07:57:10
 
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>
                <CollectionStructur
Type>
                    <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>
          
k>
                    <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 y
ve 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.
**********************************************************************



--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>