Form Contents
Search Fields
Search Orders for:
Selected Row for Multiple Rows of Data
XPath Query Results
Select Queries
Query 1.1 - Select the search field from the form fields
Erik
Query 1.2 - Select the title of the second book
Harry Potter
Query 1.3 - Select the title of the book based on an index value provided
XQuery Kick Start
Query 1.4 - Select the year of the first book in the WEB category
2003
Query 1.5 - Select the category name description of all the book categories that have orders
Web Reference Books
Query 1.6 - Select the title of the first book by an author called Erik
Everyday Italian
Query 1.7 - Select the title of books by an author searched for, that are in english
Learning XML
Checking Queries
Query 2.1 - Check if the selectedBookNumber field has a value
3
Query 2.2 - Check if the fourth category does not have a category type defined
true
Query 2.3 - Select the first book orders price with book prices over 35
49.99
Functions to manipulate values
Query 3.1 - Select the author of the book and join with the title placed in quotes
Erik De Laurentiis wrote "Everyday Italian"
Query 3.2 - Shorten the year value of the first book by removing the century
05
Query 3.3 - Merge ‘**’ fields with the last two digits of the first books year
**05
Query 3.4 - Round the price of book 2
30
Query 3.5 - Count how many books ordered
4
Query 3.6 - Sum all the prices of the books ordered
149.93
Query 3.7 - Average value of books ordered
37.4825
Query 3.8 - Always perform
true