Adding a let clause : let « XQuery « XML






Adding a let clause




File: Data.xml
<order>
  <car model="A">
    <id>0001</id>
    <name language="en">name 1</name>
    <colorChoices>navy black</colorChoices>
  </car>
  <car model="B">
    <id>0002</id>
    <name language="en">name 2</name>
  </car>
  <car model="B">
    <id>0003</id>
    <name language="en">name 3</name>
  </car>
</order>

File: Query.xquery
for $car in doc("Data.xml")/order/car
let $name := $car/name
where $car/@model = "B"
order by $name
return $name

Output:

<?xml version="1.0" encoding="UTF-8"?>
<name language="en">name 2</name>
<name language="en">name 3</name>

 








Related examples in the same category

1.Using a let clause with a range expression
2.Intermingled for and let clauses
3.Let stateCt