For stateCt : for « XQuery « XML

1. XML
2. XQuery
3. for

For stateCt

File: Data.xml


<!-- Order input docuCt -->
<order num="00299432" date="2006-09-15" cust="0221A">
  <item dept="A" num="1" quantity="1" color="navy"/>
  <item dept="B" num="2" quantity="1"/>
  <item dept="B" num="3" quantity="2"/>
  <item dept="C" num="4" quantity="1" color="white"/>
  <item dept="C" num="4" quantity="1" color="gray"/>
  <item dept="A" num="1" quantity="1" color="black"/>
</order>



File: Query.xquery

<title>Order Report</title>,
(for $item in doc("Data.xml")//item
 order by $item/@num
 return $item)


Output:

<?xml version="1.0" encoding="UTF-8"?>
<title>Order Report</title>
<item dept="A" num="1" quantity="1" color="navy"/>
<item dept="A" num="1" quantity="1" color="black"/>
<item dept="B" num="2" quantity="1"/>
<item dept="B" num="3" quantity="2"/>
<item dept="C" num="4" quantity="1" color="white"/>
<item dept="C" num="4" quantity="1" color="gray"/>

 

Related examples in the same category