how to filter xml with group wise?

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
This is my xml file

<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; hotels<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; hotelId<span style="color:Blue; >1001<span style="color:Blue; </<span style="color:#A31515; hotelId<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; boardType<span style="color:Blue; >Room Only<span style="color:Blue; </<span style="color:#A31515; boardType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; rooms<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Standard Single Room<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >10<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Standard Single Room<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Child<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >15<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Standard Single Room<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Child<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >14<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >20<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Standard Single Room<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >20<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Standard Single Room<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Child<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >14<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Child<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >10<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >25<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Standard Single Room<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Child<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >14<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Child<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >10<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >20<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Standard Single Room<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >20<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; rooms<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; hotelId<span style="color:Blue; >1002<span style="color:Blue; </<span style="color:#A31515; hotelId<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; boardType<span style="color:Blue; >Room Only<span style="color:Blue; </<span style="color:#A31515; boardType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; rooms<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Double/twin Deluxe<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >10<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Double/twin Superior<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >12<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; rooms<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; hotelId<span style="color:Blue; >1003<span style="color:Blue; </<span style="color:#A31515; hotelId<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; boardType<span style="color:Blue; >Bed And Breakfast<span style="color:Blue; </<span style="color:#A31515; boardType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; rooms<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; roomCategory<span style="color:Blue; >Double/twin Deluxe<span style="color:Blue; </<span style="color:#A31515; roomCategory<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Adult<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >30<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; paxType<span style="color:Blue; >Child<span style="color:Blue; </<span style="color:#A31515; paxType<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; age<span style="color:Blue; >3<span style="color:Blue; </<span style="color:#A31515; age<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; paxes<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; totalRoomRate<span style="color:Blue; >20<span style="color:Blue; </<span style="color:#A31515; totalRoomRate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; rooms<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; item<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; hotels<span style="color:Blue; >
[/code]
<br/>
<br/>

XML output i showing below
------------------------------------------------------------------------------------------------------------
<span style="text-decoration:underline Hotel ID: 1001
Room Type Board Type Quantity Adults Child Price
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 1 1
0 10<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 1 1
1 15<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 1 1
1 20<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 1 2
0 20<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 1 1
2 25<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 1 1
2 20<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 1 2
0 20

<span style="text-decoration:underline Hotel ID: 1002
Room Type Board Type Quantity Adults Child Price
<span style="font-family:Arial; font-size:x-small Double/twin Deluxe Room Only 1
1 0 10<br/>
<span style="font-family:Arial; font-size:x-small Double/twin Deluxe Room Only 1
1 0 12
<span style="text-decoration:underline Hotel ID: 1003
Room Type Board Type Quantity Adults Child Price
<span style="font-family:Arial; font-size:x-small Double/twin Deluxe Bed And Breakfast 1 1
1 20<span style="font-family:Arial; font-size:x-small <br/>

------------------------------------------------------------------------------------------------------------
But i need to filter the above results with xsl like below
------------------------------------------------------------------------------------------------------------
<span style="text-decoration:underline Hotel ID: 1001
Room Type Board Type Quantity Adults Child Price
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 1 1
0 10<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 2 1
1 35<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 2 2
0 40<br/>
<span style="font-family:Arial; font-size:x-small Standard Single Room Room Only 2 1
2 45
<span style="text-decoration:underline Hotel ID: 1002
Room Type Board Type Quantity Adults Child Price
<span style="font-family:Arial; font-size:x-small Double/twin Deluxe Room Only 2
1 0 22<span style="font-family:Arial; font-size:x-small <br/>

<span style="text-decoration:underline Hotel ID: 1003
Room Type Board Type Quantity Adults Child Price
<span style="font-family:Arial; font-size:x-small Double/twin Deluxe Bed And Breakfast 1 1
1 20<span style="font-family:Arial; font-size:x-small <br/>

------------------------------------------------------------------------------------------------------------
1. if you take total quantity it should be on same "Room Type", "Board Type", "Adults" and "Child"
1. if you take total Price it should be the total of that group
How i do this in xsl file
hoping your help
<span style="font-family:Arial; font-size:x-small <br/>


View the full article
 
Back
Top