[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] 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. **********************************************************************
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|