|
File: Data.xml
<order>
<car model="A">
<id>0001</id>
<name language="en">name 1</name>
</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 $prod in (doc("Data.xml")/order/car)
return if ($prod/@model = 'ACC')
then <accessoryid>{data($prod/id)}</accessoryid>
else <otherid>{data($prod/id)}</otherid>
Output:
<?xml version="1.0" encoding="UTF-8"?>
<otherid>0001</otherid>
<otherid>0002</otherid>
<otherid>0003</otherid>
|