XQuery Add

XQuery Add is used for adding elements, attributes, HTML elements and text in the results from the input documents.

Let's understand it by using an example.

XQuery Add Example

Take an XML file named books.xml, having the following data.

books.xml

<bookstore>
<book category="Mythology">
<title lang="en">Immortals of Meluha</title>
<author>Amish</author>
<year>2010</year>
<price>180</price>
</book>
<book category="Children">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>300</price>
</book>
<book category="Programming">
<title lang="en">Let's C</title>
<author>Yashwant Kanetkar</author>
<year>2003</year>
<price>200</price>
</book>
</bookstore>

XQuery Expression

books.xqy

for $x in doc("books.xml")/bookstore/book/title
order by $x
return $x

Now this XQuery expression will return the title elements in the same manner as they are described in the input document.

Output:

Now you can add your own elements and attributes to the result.

Add HTML Elements and Text

If you want to add some HTML elements to the result, use the XQuery like this:

book.xqy:

<html>
<body>

<h1>Bookstore</h1>
<ul>
{
for $x in doc("books.xml")/bookstore/book
order by $x/title
return <li>{data($x/title)}. Category: {data($x/@category)}</li>
}

</ul>
</body>
</html>