XQuery is a language for querying XML data or non-XML data that can be modeled as XML. XQuery is specified by the W3C.
Where Java and C++ are statement-based languages, the XQuery language is expression-based. The simplest XQuery expression is an XML element constructor:
<recipe/>
This <recipe/> element is an XQuery expression that forms a complete XQuery. In fact, this XQuery doesn't actually query anything. It just creates an empty <recipe/> element in the output. But constructing new elements in an XQuery is often necessary.
An XQuery expression can also be enclosed in curly braces and embedded in another XQuery expression. This XQuery has a document expression embedded in a node expression:
<html xmlns="http://www.w3.org/1999/xhtml/"
xml:id="{doc("other.html")/html/@xml:id}"/>
It creates a new <html> element in the output and sets its id attribute to be the id attribute from an <html> element in the other.html file.
In C++ and Java, we write nested for loops and recursive functions to traverse XML trees in search of elements of interest. In XQuery, we write these iterative and recursive algorithms with path expressions.
A path expression looks somewhat like a typical file pathname for locating a file in a hierarchical file system. It is a sequence of one or more steps separated by slash '/' or double slash '//'. Although path expressions are used for traversing XML trees, not file systems, in QtXmlPatterms we can model a file system to look like an XML tree, so in QtXmlPatterns we can use XQuery to traverse a file system. See the file system example.
Think of a path expression as an algorithm for traversing an XML tree to find and collect items of interest. This algorithm is evaluated by evaluating each step moving from left to right through the sequence. A step is evaluated with a set of input items (nodes and atomic values), sometimes called the focus. The step is evaluated for each item in the focus. These evaluations produce a new set of items, called the result, which then becomes the focus that is passed to the next step. Evaluation of the final step produces the final result, which is the result of the XQuery. The items in the result set are presented in document order and without duplicates.
With QtXmlPatterns, a standard way to present the initial focus to a query is to call QXmlQuery::setFocus(). Another common way is to let the XQuery itself create the initial focus by using the first step of the path expression to call the XQuery doc() function. The doc() function loads an XML document and returns the document node. Note that the document node is not the same as the document element. The document node is a node constructed in memory, when the document is loaded. It represents the entire XML document, not the document element. The document element is the single, top-level XML element in the file. The doc() function returns the document node, which becomes the singleton node in the initial focus set. The document node will have one child node, and that child node will represent the document element. Consider the following XQuery:
doc('cookbook.xml')//recipe
The doc() function loads the cookbook.xml file and returns the document node. The document node then becomes the focus for the next step //recipe. Here the double slash means select all <recipe> elements found below the document node, regardless of where they appear in the document tree. The query selects all <recipe> elements in the cookbook. See Running The Cookbook Examples for instructions on how to run this query (and most of the ones that follow) from the command line.
Conceptually, evaluation of the steps of a path expression is similar to iterating through the same number of nested for loops. Consider the following XQuery, which builds on the previous one:
doc('cookbook.xml')//recipe/title
This XQuery is a single path expression composed of three steps. The first step creates the initial focus by calling the doc() function. We can paraphrase what the query engine does at each step:
Again the double slash means select all the <recipe> elements in the document. The single slash before the <title> element means select only those <title> elements that are child elements of a <recipe> element (i.e. not grandchildren, etc). The XQuery evaluates to a final result set containing the <title> element of each <recipe> element in the cookbook.
The most common kind of path step is called an axis step, which tells the query engine which way to navigate from the context node, and which test to perform when it encounters nodes along the way. An axis step has two parts, an axis specifier, and a node test. Conceptually, evaluation of an axis step proceeds as follows: For each node in the focus set, the query engine navigates out from the node along the specified axis and applies the node test to each node it encounters. The nodes selected by the node test are collected in the result set, which becomes the focus set for the next step.
In the example XQuery above, the second and third steps are both axis steps. Both apply the element(name) node test to nodes encountered while traversing along some axis. But in this example, the two axis steps are written in a shorthand form, where the axis specifier and the node test are not written explicitly but are implied. XQueries are normally written in this shorthand form, but they can also be written in the longhand form. If we rewrite the XQuery in the longhand form, it looks like this:
doc('cookbook.xml')/descendant-or-self::element(recipe)/child::element(title)
The two axis steps have been expanded. The first step (//recipe) has been rewritten as /descendant-or-self::element(recipe), where descendant-or-self:: is the axis specifier and element(recipe) is the node test. The second step (title) has been rewritten as /child::element(title), where child:: is the axis specifier and element(title) is the node test. The output of the expanded XQuery will be exactly the same as the output of the shorthand form.
To create an axis step, concatenate an axis specifier and a node test. The following sections list the axis specifiers and node tests that are available.
An axis specifier defines the direction you want the query engine to take, when it navigates away from the context node. QtXmlPatterns supports the following axes.
| Axis Specifier | refers to the axis containing... |
|---|---|
self:: | the context node itself |
attribute:: | all attribute nodes of the context node |
child:: | all child nodes of the context node (not attributes) |
descendant:: | all descendants of the context node (children, grandchildren, etc) |
descendant-or-self:: | all nodes in descendant + self |
parent:: | the parent node of the context node, or empty if there is no parent |
ancestor:: | all ancestors of the context node (parent, grandparent, etc) |
ancestor-or-self:: | all nodes in ancestor + self |
following:: | all nodes in the tree containing the context node, not including descendant, and that follow the context node in the document |
preceding:: | all nodes in the tree contianing the context node, not including ancestor, and that precede the context node in the document |
following-sibling:: | all children of the context node's parent that follow the context node in the document |
preceding-sibling:: | all children of the context node's parent that precede the context node in the document |
A node test is a conditional expression that must be true for a node if the node is to be selected by the axis step. The conditional expression can test just the kind of node, or it can test the kind of node and the name of the node. The XQuery specification for node tests also defines a third condition, the node's Schema Type, but schema type tests are not supported in QtXmlPatterns.
QtXmlPatterns supports the following node tests. The tests that have a name parameter test the node's name in addition to its kind and are often called the Name Tests.
| Node Test | matches all... |
|---|---|
node() | nodes of any kind |
text() | text nodes |
comment() | comment nodes |
element() | element nodes (same as star: *) |
element(name) | element nodes named name |
attribute() | attribute nodes |
attribute(name) | attribute nodes named name |
processing-instruction() | processing-instructions |
processing-instruction(name) | processing-instructions named name |
document-node() | document nodes (there is only one) |
document-node(element(name)) | document node with document element name |
Writing axis steps using the longhand form with axis specifiers and node tests is semantically clear but syntactically verbose. The shorthand form is easy to learn and, once you learn it, just as easy to read. In the shorthand form, the axis specifier and node test are implied by the syntax. XQueries are normally written in the shorthand form. Here is a table of some frequently used shorthand forms:
| Shorthand syntax | Short for... | matches all... |
|---|---|---|
name | child::element(name) | child nodes that are name elements |
* | child::element() | child nodes that are elements (node() matches all child nodes) |
.. | parent::node() | parent nodes (there is only one) |
@* | attribute::attribute() | attribute nodes |
@name | attribute::attribute(name) | name attributes |
// | descendant-or-self::node() | descendent nodes (when used instead of '/') |
The XQuery language specification has a more detailed section on the shorthand form, which it calls the abbreviated syntax. More examples of path expressions written in the shorthand form are found there. There is also a section listing examples of path expressions written in the longhand form.
The name tests are the Node Tests that have the name parameter. A name test must match the node name in addition to the node kind. We have already seen name tests used:
doc('cookbook.xml')//recipe/title
In this path expression, both recipe and title are name tests written in the shorthand form. XQuery resolves these names (QNames) to their expanded form using whatever namespace declarations it knows about. Resolving a name to its expanded form means replacing its namespace prefix, if one is present (there aren't any present in the example), with a namespace URI. The expanded name then consists of the namespace URI and the local name.
But the names in the example above don't have namespace prefixes, because we didn't include a namespace declaration in our cookbook.xml file. However, we will often use XQuery to query XML documents that use namespaces. Forgetting to declare the correct namespace(s) in an XQuery is a common cause of XQuery failures. Let's add a default namespace to cookbook.xml now. Change the document element in cookbook.xml from:
<cookbook>
to...
<cookbook xmlns="http://cookbook/namespace">
This is called a default namespace declaration because it doesn't include a namespace prefix. By including this default namespace declaration in the document element, we mean that all unprefixed element names in the document, including the document element itself (cookbook), are automatically in the default namespace http://cookbook/namespace. Note that unprefixed attribute names are not affected by the default namespace declaration. They are always considered to be in no namespace. Note also that the URL we choose as our namespace URI need not refer to an actual location, and doesn't refer to one in this case. But click on http://www.w3.org/XML/1998/namespace, for example, which is the namespace URI for elements and attributes prefixed with xml:.
Now when we try to run the previous XQuery example, no output is produced! The path expression no longer matches anything in the cookbook file because our XQuery doesn't yet know about the namespace declaration we added to the cookbook document. There are two ways we can declare the namespace in the XQuery. We can give it a namespace prefix (e.g. c for cookbook) and prefix each name test with the namespace prefix:
declare namespace c = "http://cookbook/namespace";
doc('cookbook.xml')//c:recipe/c:title
Or we can declare the namespace to be the default element namespace, and then we can still run the original XQuery:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')//recipe/title
Both methods will work and produce the same output, all the <title> elements:
<title xmlns="http://cookbook/namespace">Quick and Easy Mushroom Soup</title> <title xmlns="http://cookbook/namespace">Cheese on Toast</title> <title xmlns="http://cookbook/namespace">Hard-Boiled Eggs</title>
But note how the output is slightly different from the output we saw before we added the default namespace declaration to the cookbook file. QtXmlPatterns automatically includes the correct namespace attribute in each <title> element in the output. When QtXmlPatterns loads a document and expands a QName, it creates an instance of QXmlName, which retains the namespace prefix along with the namespace URI and the local name. See QXmlName for further details.
One thing to keep in mind from this namespace discussion, whether you run XQueries in a Qt program using QtXmlPatterns, or you run them from the command line using xmlpatterns, is that if you don't get the output you expect, it might be because the data you are querying uses namespaces, but you didn't declare those namespaces in your XQuery.
The wildcard '*' can be used in a name test. To find all the attributes in the cookbook but select only the ones in the xml namespace, use the xml: namespace prefix but replace the local name (the attribute name) with the wildcard:
doc('cookbook.xml')//@xml:*
Oops! If you save this XQuery in file.xq and run it through xmlpatterns, it doesn't work. You get an error message instead, something like this: Error SENR0001 in file:///...file.xq, at line 1, column 1: Attribute xml:id can't be serialized because it appears at the top level. The XQuery actually ran correctly. It selected a bunch of xml:id attributes and put them in the result set. But then xmlpatterns sent the result set to a serializer, which tried to output it as well-formed XML. Since the result set contains only attributes and attributes alone are not well-formed XML, the serializer reports a serialization error.
Fear not. XQuery can do more than just find and select elements and attributes. It can construct new ones on the fly as well, which is what we need to do here if we want xmlpatterns to let us see the attributes we selected. The example above and the ones below are revisited in the Constructing Elements section. You can jump ahead to see the modified examples now, and then come back, or you can press on from here.
To find all the name attributes in the cookbook and select them all regardless of their namespace, replace the namespace prefix with the wildcard and write name (the attribute name) as the local name:
doc('cookbook.xml')//@*:name
To find and select all the attributes of the document element in the cookbook, replace the entire name test with the wildcard:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')/cookbook/@*
Predicates can be used to further filter the nodes selected by a path expression. A predicate is an expression in square brackets ('[' and ']') that either returns a boolean value or a number. A predicate can appear at the end of any path step in a path expression. The predicate is applied to each node in the focus set. If a node passes the filter, the node is included in the result set. The query below selects the recipe element that has the <title> element "Hard-Boiled Eggs".
declare default element namespace "http://cookbook/namespace";
doc("cookbook.xml")/cookbook/recipe[title = "Hard-Boiled Eggs"]
The dot expression ('.') can be used in predicates and path expressions to refer to the current context node. The following query uses the dot expression to refer to the current <method> element. The query selects the empty <method> elements from the cookbook.
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')//method[string-length(.) = 0]
Note that passing the dot expression to the string-length() function is optional. When string-length() is called with no parameter, the context node is assumed:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')//method[string-length() = 0]
Actually, selecting an empty <method> element might not be very useful by itself. It doesn't tell you which recipe has the empty method:
<method xmlns="http://cookbook/namespace"/>
What you probably want to see instead are the <recipe> elements that have empty <method> elements:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')//recipe[string-length(method) = 0]
The predicate uses the string-length() function to test the length of each <method> element in each <recipe> element found by the node test. If a <method> contains no text, the predicate evaluates to true and the <recipe> element is selected. If the method contains some text, the predicate evaluates to false, and the <recipe> element is discarded. The output is the entire recipe that has no instructions for preparation:
<recipe xmlns="http://cookbook/namespace" xml:id="HardBoiledEggs">
<title>Hard-Boiled Eggs</title>
<ingredient name="Eggs" quantity="3" unit="eggs"/>
<time quantity="3" unit="minutes"/>
<method/>
</recipe>
The astute reader will have noticed that this use of string-length() to find an empty element is unreliable. It works in this case, because the method element is written as <method/>, guaranteeing that its string length will be 0. It will still work if the method element is written as <method></method>, but it will fail if there is any whitespace between the opening and ending <method> tags. A more robust way to find the recipes with empty methods is presented in the section on Boolean Predicates.
There are many more functions and operators defined for XQuery and XPath. They are all documented in the specification.
Predicates are often used to filter items based on their position in a sequence. For path expressions processing items loaded from XML documents, the normal sequence is document order. This query returns the second <recipe> element in the cookbook.xml file:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')/cookbook/recipe[2]
The other frequently used positional function is last(), which returns the numeric position of the last item in the focus set. Stated another way, last() returns the size of the focus set. This query returns the last recipe in the cookbook:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')/cookbook/recipe[last()]
And this query returns the next to last <recipe>:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')/cookbook/recipe[last() - 1]
The other kind of predicate evaluates to true or false. A boolean predicate takes the value of its expression and determines its effective boolean value according to the following rules:
We have already seen some boolean predicates in use. Earlier, we saw a not so robust way to find the recipes that have no instructions. [string-length(method) = 0] is a boolean predicate that would fail in the example if the empty method element was written with both opening and closing tags and there was whitespace between the tags. Here is a more robust way that uses a different boolean predicate.
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')/cookbook/recipe[method[empty(step)]]
This one uses the empty() and function to test whether the method contains any steps. If the method contains no steps, then empty(step) will return true, and hence the predicate will evaluate to true.
But even that version isn't foolproof. Suppose the method does contain steps, but all the steps themselves are empty. That's still a case of a recipe with no instructions that won't be detected. There is a better way:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')/cookbook/recipe[not(normalize-space(method))]
This version uses the not and normalize-space() functions. normalize-space(method)) returns the contents of the method element as a string, but with all the whitespace normalized, i.e., the string value of each <step> element will have its whitespace normalized, and then all the normalized step values will be concatenated. If that string is empty, then not() returns true and the predicate is true.
We can also use the position() function in a comparison to inspect positions with conditional logic. The position() function returns the position index of the current context item in the sequence of items:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')/cookbook/recipe[position() = 2]
Note that the first position in the sequence is position 1, not 0. We can also select all the recipes after the first one:
declare default element namespace "http://cookbook/namespace";
doc('cookbook.xml')/cookbook/recipe[position() > 1]
In the section about using wildcards in name tests, we saw three simple example XQueries, each of which selected a different list of XML attributes from the cookbook. We couldn't use xmlpatterns to run these queries, however, because xmlpatterns sends the XQuery results to a serializer, which expects to serialize the results as well-formed XML. Since a list of XML attributes by itself is not well-formed XML, the serializer reported an error for each XQuery.
Since an attribute must appear in an element, for each attribute in the result set, we must create an XML element. We can do that using a for clause with a bound variable, and a return clause with an element constructor:
for $i in doc("cookbook.xml")//@xml:*
return <p>{$i}</p>
The for clause produces a sequence of attribute nodes from the result of the path expression. Each attribute node in the sequence is bound to the variable $i. The return clause then constructs a <p> element around the attribute node. Here is the output:
<p xml:id="MushroomSoup"/> <p xml:id="CheeseOnToast"/> <p xml:id="HardBoiledEggs"/>
The output contains one <p> element for each xml:id attribute in the cookbook. Note that XQuery puts each attribute in the right place in its <p> element, despite the fact that in the return clause, the $i variable is positioned as if it is meant to become <p> element content.
The other two examples from the wildcard section can be rewritten the same way. Here is the XQuery that selects all the name attributes, regardless of namespace:
for $i in doc("cookbook.xml")//@*:name
return <p>{$i}</p>
And here is its output:
<p name="Fresh mushrooms"/> <p name="Garlic"/> <p name="Olive oil"/> <p name="Milk"/> <p name="Water"/> <p name="Cream"/> <p name="Vegetable soup cube"/> <p name="Ground black pepper"/> <p name="Dried parsley"/> <p name="Bread"/> <p name="Cheese"/> <p name="Eggs"/>
And here is the XQuery that selects all the attributes from the document element:
declare default element namespace "http://cookbook/namespace";
for $i in doc("cookbook.xml")/cookbook/@*
return <p>{$i}</p>
And here is its output:
<p xmlns="http://cookbook/namespace" count="3"/>
Because node constructors are expressions, they can be used in XQueries wherever expressions are allowed.
declare default element namespace "http://cookbook/namespace";
let $docURI := 'cookbook.xml'
return if(doc-available($docURI))
then doc($docURI)//recipe/<oppskrift>{./node()}</oppskrift>
else <oppskrift>Failed to load {$docURI}</oppskrift>
If cookbook.xml is loaded without error, a <oppskrift> element (Norwegian word for recipe) is constructed for each <recipe> element in the cookbook, and the child nodes of the <recipe> are copied into the <oppskrift> element. But if the cookbook document doesn't exist or does not contain well-formed XML, a single <oppskrift> element is constructed containing an error message.
XQuery also has atomic values. An atomic value is a value in the value space of one of the built-in datatypes in the XML Schema language. These atomic types have built-in operators for doing arithmetic, comparisons, and for converting values to other atomic types. See the Built-in Datatype Hierarchy for the entire tree of built-in, primitive and derived atomic types. Note: Click on a data type in the tree for its detailed specification.
To construct an atomic value as element content, enclose an expression in curly braces and embed it in the element constructor:
<e>{sum((1, 2, 3))}</e>
Sending this XQuery through xmlpatterns produces:
<e>6</e>
To compute the value of an attribute, enclose the expression in curly braces and embed it in the attribute value:
declare variable $insertion := "example";
<p class="important {$insertion} obsolete"/>
Sending this XQuery through xmlpatterns produces:
<p class="important example obsolete"/>
declare default element namespace "http://cookbook/namespace";
let $docURI := 'cookbook.xml'
return if(doc-available($docURI))
then doc($docURI)//recipe/<oppskrift>{./node()}</oppskrift>
else <oppskrift>Failed to load {$docURI}</oppskrift>
If cookbook.xml is loaded without error, a <oppskrift> element (Norweigian word for recipe) is constructed for each <recipe> element in the cookbook, and the child nodes of the <recipe> are copied into the <oppskrift> element. But if the cookbook document doesn't exist or does not contain well-formed XML, a single <oppskrift> element is constructed containing an error message.
Most of the XQuery examples in this document refer to the cookbook.xml example file from the Recipes Example. Copy the cookbook.xml to your current directory, save one of the cookbook XQuery examples in a .xq file (e.g., file.xq), and run the XQuery using Qt's command line utility:
xmlpatterns file.xq
There is much more to the XQuery language than we have presented in this short introduction. We will be adding more here in later releases. In the meantime, playing with the xmlpatterns utility and making modifications to the XQuery examples provided here will be quite informative. An XQuery textbook will be a good investment.
You can also ask questions on XQuery mail lists:
FunctX has a collection of XQuery functions that can be both useful and educational.
This introduction contains many links to the specifications, which, of course, are the ultimate source of information about XQuery. They can be a bit difficult, though, so consider investing in a textbook:
The answers to these frequently asked questions explain the causes of several common mistakes that most beginners make. Reading through the answers ahead of time might save you a lot of head scratching.
The most common cause of this bug is failure to declare one or more namespaces in your XQuery. Consider the following query for selecting all the examples in an XHTML document:
doc("index.html")/html/body/p[@class="example"]
It won't match anything because index.html is an XHTML file, and all XHTML files declare the default namespace "http://www.w3.org/1999/xhtml" in their top (<html>) element. But the query doesn't declare this namespace, so the path expression expands html to {}html and tries to match that expanded name. But the actual expanded name is {http://www.w3.org/1999/xhtml}html. One possible fix is to declare the correct default namespace in the XQuery:
declare namespace x = "http://www.w3.org/1999/xhtml/";
doc("index.html")/x:html/x:body/x:p[@class="example"]
Another common cause of this bug is to confuse the document node with the top element node. They are different. This query won't match anything:
doc("myPlainHTML.html")/body
The doc() function returns the document node, not the top element node (<html>). Don't forget to match the top element node in the path expression:
doc("myPlainHTML.html")/html/body
Just remember to declare both namespaces in your XQuery and use them properly. Consider the following query, which is meant to generate XHTML output from XML input:
declare default element namespace "http://www.w3.org/1999/xhtml";
<html>
<body>
{
for $i in doc("testResult.xml")/tests/test[@status = "failure"]
order by $i/@name
return <p>{$i/@name}</p>
}
</body>
</html>
We want the <html>, <body>, and <p> nodes we create in the output to be in the standard XHTML namespace, so we declare the default namespace to be http://www.w3.org/1999/xhtml. That's correct for the output, but that same default namespace will also be applied to the node names in the path expression we're trying to match in the input (/tests/test[@status = "failure"]), which is wrong, because the namespace used in testResult.xml is perhaps in the empty namespace. So we must declare that namespace too, with a namespace prefix, and then use the prefix with the node names in the path expression. This one will probably work better:
declare namespace x = "http://www.w3.org/1998/xhtml";
<x:html>
<x:body>
{
for $i in doc("testResult.xml")/tests/test[@status = "failure"]
order by $i/@name
return <x:p>{$i/@name}</x:p>
}
</x:body>
</x:html>
Recall that XQuery is an expression-based language, not statement-based. Because an XQuery is a lot of expressions, understanding XQuery expression precedence is very important. Consider the following query:
for $i in(reverse(1 to 10)),
$d in xs:integer(doc("numbers.xml")/numbers/number)
return $i + $d
It looks ok, but it isn't. It is supposed to be a FLWOR expression comprising a for clause and a return clause, but it isn't just that. It has a FLWOR expression, certainly (with the for and return clauses), but it also has an arithmetic expression (+ $d) dangling at the end because we didn't enclose the return expression in parentheses.
Using parentheses to establish precedence is more important in XQuery than in other languages, because XQuery is expression-based. In In this case, without parantheses enclosing $i + $d, the return clause only returns $i. The +$d will have the result of the FLWOR expression as its left operand. And, since the scope of variable $d ends at the end of the return clause, a variable out of scope error will be reported. Correct these problems by using parentheses.
for $i in(reverse(1 to 10)),
$d in xs:integer(doc("numbers.xml")/numbers/number)
return ($i + $d)
You probably misplaced some curly braces. When you want an expression evaluated inside an element constructor, enclose the expression in curly braces. Without the curly braces, the expression will be interpreted as text. Here is a sum() expression used in an <e> element. The table shows cases where the curly braces are missing, misplaced, and placed correctly:
| element constructor with expression... | evaluates to... |
|---|---|
<e>sum((1, 2, 3))</e> | <e>sum((1, 2, 3))</e> |
<e>sum({(1, 2, 3)})</e> | <e>sum(1 2 3)</e> |
<e>{sum((1, 2, 3))}</e> | <e>6</e> |
Either you put your predicate in the wrong place in your path expression, or you forgot to add some parentheses. Consider this input file doc.txt:
<doc>
<p>
<span>1</span>
<span>2</span>
</p>
<p>
<span>3</span>
<span>4</span>
</p>
<p>
<span>5</span>
<span>6</span>
</p>
<p>
<span>7</span>
<span>8</span>
</p>
<p>
<span>9</span>
<span>a</span>
</p>
<p>
<span>b</span>
<span>c</span>
</p>
<p>
<span>d</span>
<span>e</span>
</p>
<p>
<span>f</span>
<span>0</span>
</p>
</doc>
Suppose you want the first <span> element of every <p> element. Apply a position filter ([1]) to the /span path step:
let $doc := doc('doc.txt')
return $doc/doc/p/span[1]
Applying the [1] filter to the /span step returns the first <span> element of each <p> element:
<span>1</span> <span>3</span> <span>5</span> <span>7</span> <span>9</span> <span>b</span> <span>d</span> <span>f</span>
Note:: You can write the same query this way:
for $a in doc('doc.txt')/doc/p/span[1]
return $a
Or you can reduce it right down to this:
doc('doc.txt')/doc/p/span[1]
On the other hand, suppose you really want only one <span> element, the first one in the document (i.e., you only want the first <span> element in the first <p> element). Then you have to do more filtering. There are two ways you can do it. You can apply the [1] filter in the same place as above but enclose the path expression in parentheses:
let $doc := doc('doc.txt')
return ($doc/doc/p/span)[1]
Or you can apply a second position filter ([1] again) to the /p path step:
let $doc := doc('doc.txt')
return $doc/doc/p[1]/span[1]
Either way the query will return only the first <span> element in the document:
<span>1</span>
The quick answer is you probably expected your XQuery FLWOR to behave just like a C++ for loop. But they aren't the same. Consider a simple example:
for $a in (8, -4, 2) let $b := ($a * -1, $a) order by $a return $b
This query evaluates to 4 -4 -2 2 -8 8. The for clause does set up a for loop style iteration, which does evaluate the rest of the FLWOR multiple times, one time for each value returned by the in expression. That much is similar to the C++ for loop.
But consider the return clause. In C++ if you hit a return statement, you break out of the for loop and return from the function with one value. Not so in XQuery. The return clause is the last clause of the FLWOR, and it means: Append the return value to the result list and then begin the next iteration of the FLWOR. When the for clause's in expression no longer returns a value, the entire result list is returned.
Next, consider the order by clause. It doesn't do any sorting on each iteration of the FLWOR. It just evaluates its expression on each iteration ($a in this case) to get an ordering value to map to the result item from each iteration. These ordering values are kept in a parallel list. The result list is sorted at the end using the parallel list of ordering values.
The last difference to note here is that the let clause does not set up an iteration through a sequence of values like the for clause does. The let clause isn't a sort of nested loop. It isn't a loop at all. It is just a variable binding. On each iteration, it binds the entire sequence of values on the right to the variable on the left. In the example above, it binds (4 -4) to $b on the first iteration, (-2 2) on the second iteration, and (-8 8) on the third iteration. So the following query doesn't iterate through anything, and doesn't do any ordering:
let $i := (2, 3, 1) order by $i[1] return $i
It binds the entire sequence (2, 3, 1) to $i one time only; the order by clause only has one thing to order and hence does nothing, and the query evaluates to 2 3 1, the sequence assigned to $i.
Note: We didn't include a where clause in the example. The where clause is for filtering results.
The short answer is your elements are not created in the wrong order, because when appearing as operands to a path expression, there is no correct order. Consider the following query, which again uses the input file doc.txt:
doc('doc.txt')//p/<p>{span/node()}</p>
The query finds all the <p> elements in the file. For each <p> element, it builds a <p> element in the output containing the concatenated contents of all the <p> element's child <span> elements. Running the query through xmlpatterns might produce the following output, which is not sorted in the expected order.
<p>78</p> <p>9a</p> <p>12</p> <p>bc</p> <p>de</p> <p>34</p> <p>56</p> <p>f0</p>
You can use a for loop to ensure that the order of the result set corresponds to the order of the input sequence:
for $a in doc('doc.txt')//p
return <p>{$a/span/node()}</p>
This version produces the same result set but in the expected order:
<p>12</p> <p>34</p> <p>56</p> <p>78</p> <p>9a</p> <p>bc</p> <p>de</p> <p>f0</p>
You can, but not by just using the names true and false directly, because they are name tests although they look like boolean constants. The simple way to create the boolean values is to use the builtin functions true() and false() wherever you want to use true and false. The other way is to invoke the boolean constructor:
xs:boolean("true")