Filtering with where clauses

100%

Filtering with where clauses

✓ Published0🌍 Public

Last edited Jul 28, 2017

Created on Jul 28, 2017

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.

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

79% match

Loading thumbnail…

FWLOR with order by Example

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.

CCliffordAnderson

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

72% match

Loading thumbnail…

Simple Books Document

This example visualizes a small set of books from an XML data source, grouping them by their `class` attribute (fiction or nonfiction). It first shows the hierarchical document structure as a simple indented list, then renders each book as a colored node in a force-directed graph. The visualization uses D3.js’s `d3.hierarchy` and `d3.tree` to lay out the XML tree, while `d3.forceSimulation` positions the book nodes, with the `class` value driving node color and tooltip text. The raw XML is loaded via `d3.xml`, and the document’s structure is directly mirrored in the layout, making the data’s grouping and classification immediately visible.

CCliffordAnderson

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

63% match

Loading thumbnail…

Making comparisons in XQuery

XQuery’s comparison operators are demonstrated through paired queries that contrast general comparisons with existential quantifiers. The code uses the XQuery `some`/`every` expressions and `satisfies` clauses to test set membership, while `=` and `eq` show value-based versus sequence-based equality. The examples, sourced from a gist, handle XML data with `isbn` attributes and use `where` clauses with `@num` comparisons. A node identity check via the `is` operator highlights how XQuery distinguishes node identity from value equality, all rendered in concise .xqy files.

CCliffordAnderson

60% 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…

New Books

This example visualizes the distribution of new books across fiction and nonfiction genres. It reads the `books.xml` file and renders each book as a point on a simple scatter plot, with the class attribute determining the point’s color. The visualization uses the D3.js library, specifically `d3.forceSimulation` for layout and `d3.select` with `svg.circle` to draw the data marks, providing a clear, immediate comparison of genre counts from this small gist dataset.

CCliffordAnderson

58% match