Grouping example

100%

Grouping example

✓ Published0🌍 Public

Last edited Oct 2, 2015

Created on Oct 2, 2015

This example shows how XQuery groups report records by author and clearance status, revealing the distribution of cleared, not acquired, and unknown items per author. It first defines a function that maps numeric clearance flags to categorical labels, then queries the `ReportMaster` collection. Using the `group by` clause, it aggregates records by both author and status, while `fn:replace` extracts the author’s surname for ordering. The output is a series of `<report>` elements containing the author and status. The code relies on the XQuery 3.1 standard, specifically the `collection` function and `group by` syntax, with no external visualization libraries.

AI-generated description

Similar vizzes

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

65% match

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

62% match

Loading thumbnail…

Management XQuery Exercise

This example shows how XQuery 3.1 can structure and filter flat HTML documents, specifically extracting sections from a management report. It uses `fn:collection()` to load source documents, `fn:index-of()` and positional predicates to locate and slice a section between “ITEM 1A” and “ITEM 1B,” and text-matching (`contains text`) to filter paragraphs for keywords like “refinery.” The final query, `return-items-filtered.xqy`, cleans results by removing empty paragraphs, spans, and break tags, then wraps the output in a custom `<section>` element with an `item` attribute.

CCliffordAnderson

59% 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

57% match

Loading thumbnail…

Example XQuery for Sara S.

This example shows how to extract a three-letter publication location code from a MARC 21 control field, filtering for specific geographic designators. It uses XQuery 3.1 with the `fn:substring` function to pull characters 16 through 18 from the text of the `marc:controlfield` element with `@tag='008'`. The query defines the MARC namespace and applies a `where` clause to return only codes matching `"gau"`, `"other"`, or `"codes"`. The source is a snippet of MARCXML data embedded directly in the script, demonstrating string parsing and conditional filtering in a pure XQuery environment.

CCliffordAnderson

55% 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

54% match

Loading thumbnail…

XQuery for Author-Work-Category Graphs

An XQuery script transforms an ATLA RDB RSS feed into a GraphML network graph, linking author, work, and category nodes via hashed IDs and directed edges. The resulting graph is loaded into Neo4j using the APOC `apoc.import.graphml` procedure, which reads labels and relationships directly from the GraphML file. The visualization, rendered in Neo4j, shows the interconnected scholarly relationships, with authors and categories clustered around their respective works.

CCliffordAnderson

53% match

Loading thumbnail…

Existential Quantification in XQuery

Two XQuery expressions demonstrate existential and universal quantification over a list of author names. The first uses `every ... satisfies` to test whether all names lack a period, while the second uses `some ... satisfies` to check if at least one contains a period. Both queries evaluate against four string literals, showing how XQuery’s quantified expressions return boolean results. The embedded visual likely contrasts the two outcomes with a simple layout, though no charting library appears in the code snippets.

CCliffordAnderson

53% match