FWLOR with order by Example

100%

FWLOR with order by Example

✓ Published0🌍 Public

Last edited Jul 28, 2017

Created on Jul 28, 2017

This example demonstrates how XQuery’s FLWOR expression orders a set of book titles alphabetically, distinguishing fiction from nonfiction by class. The code defines an inline XML document containing five books, then uses the `for` and `order by` clauses to sort the sequence before returning each `book` element. The output preserves the original class attributes while arranging the titles in ascending text order. It relies on the standard XQuery evaluation environment, with no external visualization or rendering libraries, focusing purely on the query language’s ordering semantics.

AI-generated description

Similar vizzes

Loading thumbnail…

Order by & Group by in XQuery

This example demonstrates how XQuery’s `order by` and `group by` clauses transform an XML book list into grouped output. It shows the difference between sorting titles alphabetically and then grouping them by their `class` attribute, so fiction and nonfiction categories each contain their titles in order. The code defines a `books` element with five `book` children, then iterates with a `for` loop, assigns the text and class via `let`, sorts by title, and groups by class. The result returns the class followed by its titles, revealing how grouping interacts with pre-sorting. No external libraries are used, only the XQuery language’s core expressions.

CCliffordAnderson

80% match

Loading thumbnail…

Filtering with where clauses

This example shows a simple XML data filter that selects only fiction books from a hardcoded set and returns them sorted alphabetically. It uses the XQuery language, specifically the `where` clause to exclude items with a `class` attribute value of "nonfiction", and the `order by` clause to sort the remaining books by their text content. The query processes an inline `<books>` element containing five `<book>` entries, each with a `class` attribute, and returns the filtered, ordered book titles.

CCliffordAnderson

73% match

Loading thumbnail…

Example of a FLWOR expression

This example demonstrates a FLWOR expression in XQuery, showing how to compute the squares of odd numbers from 1 to 10 and return them in descending order. The data source is an inline numeric range, and the result sequence is produced by iterating with a `for` clause, binding each square with `let`, filtering odd values using a `where` condition, and sorting with `order by` before the final `return`. The code relies on the standard XQuery 3.0 library and its built-in arithmetic operators, with no external APIs or rendering components involved.

CCliffordAnderson

71% match

Loading thumbnail…

Example of grouping and counting in XQuery

This example demonstrates how to group XML elements by an attribute value and count the grouped items using XQuery 3.1’s `group by` clause. It defines a small in-memory `<books>` dataset with five book titles categorized by `class` attributes (fiction or nonfiction). The query iterates over each `<book>`, extracts the text content as titles, and groups them by class, then returns a new element named after each class containing an ordered, numbered list of titles. The implementation relies on XQuery’s `element` constructor and `count` clause to generate the output, with titles sorted alphabetically using `order by`.

CCliffordAnderson

69% match

Loading thumbnail…

Some books

This example visualizes a collection of 20 books from a CSV file, grouped by binding type into hardcover and paperback categories. It shows the distribution of books across these two formats, with each group’s count displayed as an attribute. The code uses XQuery 3.1 with `fetch:text` and `csv:parse` to load and parse the data from a Gist URL, then groups records by the `Binding` field and orders them alphabetically. The rendering approach is plain text output, with no graphical libraries, relying solely on XQuery’s element construction to list the grouped records.

CCliffordAnderson

61% match

Loading thumbnail…

ORCID names

This example shows ORCID researcher names sorted alphabetically by family name, with each entry formatted as “family name, given name.” The code queries an ORCID XML collection using XQuery 3.1, referencing the ORCID person and personal-details namespaces to extract the name components. It iterates through each `person:name` element, orders the results by family name, and joins the family and given names with a comma and space. The output is a simple list of person elements, demonstrating how XQuery’s `fn:collection` and `fn:string-join` functions can transform structured author metadata into a readable ordered sequence.

CCliffordAnderson

59% match

Loading thumbnail…

Quicksort in XQuery

This visualization compares four XQuery implementations of the quicksort algorithm, each derived from a Haskell reference, to demonstrate functional programming in a query language. It shows how the same recursive sorting logic can be expressed with different XQuery 3.1 features, including `fn:head()`, `fn:tail()`, `position()`, and a random-number generator for permutation. The code uses `local:qsort` functions with `xs:integer*` sequences, and the final example applies the sort to a shuffled list of 1 to 100 generated via `fn:random-number-generator('permute')`. The display highlights syntactical variations, such as explicit `where` clauses versus nested `if` expressions, without altering the core algorithm.

CCliffordAnderson

58% match

Loading thumbnail…

{$title || " - "}

This example displays a list of EAD (Encoded Archival Description) titles sorted alphabetically from a collection of finalized XML files, rendered as plain paragraph elements in an XHTML page. It uses XQuery 3.1 with the `fn:collection` function to gather titles from `titleproper[@type="filing"]` nodes, and a local template function `local:template` constructs the HTML output, setting a dynamic heading level and tab title. The code demonstrates a server-side, XML-to-HTML transformation pipeline without client-side JavaScript libraries or interactive visualization components.

CCliffordAnderson

58% match