---
title: Dynamic Quarries & Spreadsheet Views
category: Metadata & Views
icon: 📊
sort_order: 12
excerpt: Compile bounded structured views from note properties or portable task semantics. Canonical content remains in Markdown; saved Quarry configuration remains local workspace metadata.
slug: dynamic-quarries
canonical_url: https://phasoric.com/guides/dynamic-quarries
markdown_url: https://phasoric.com/guides/dynamic-quarries.md
---
# Dynamic Quarries & Spreadsheet Views

Compile bounded structured views from note properties or portable task semantics. Canonical content remains in Markdown; saved Quarry configuration remains local workspace metadata.

## Using Note Frontmatter

Add YAML metadata at the top of your markdown files using triple dashes:
```yaml
---
status: In Progress
priority: High
due_date: 2026-07-20
---
```

## Creating a Quarry View

1. Go to the **Quarries** page.
2. Choose **Note rows** or **Task rows**. Task rows include completion, priority, due date, source note, heading path, parent/root IDs, portable-ID status, and linked-entity counts.
3. Combine vault, search, tag, bookmark, saved-search, property, sort, and grouping controls.
4. Select a renderer:
   - **Table:** Inspect formulas and edit supported canonical note/task fields.
   - **Kanban:** Group rows and update note status or task completion.
   - **Gallery:** Scan visual cards with source and status context.
   - **Calendar:** Place dated rows on a month grid.
   - **Timeline:** Order dated rows chronologically.
   - **Chart:** Aggregate bounded row counts by a selected field.
   - **Map:** Plot note rows with numeric `latitude` and `longitude` properties using an on-device coordinate projection.
   - **List:** Review a compact source-linked row list.
   - **Dashboard:** Compose up to 12 saved note or task Quarries. Each widget retains its own row type, renderer, filters, sorting, grouping and formula settings.
5. Name and save the Quarry to persist its row type, renderer, filters, formula, sort, and grouping configuration.

## Bounded Results

Quarries retain at most 10,000 structured rows per view. Task details also respect the bounded per-note metadata index. When more rows exist than are retained, the Quarry reports the available count and truncation instead of implying that the view is complete.

Composed Dashboards materialize note and task row sets once, allow no nested Dashboards, and render at most 250 rows per widget. Tests exercise 12,000 available rows, the 10,000-row Quarry retention ceiling, the 12-widget composition ceiling, and per-widget truncation. These limits protect interactive rendering; they are not a claim that only 10,000 canonical Markdown entities exist.

When an entity participates in the trusted knowledge ledger, note and task rows also expose bounded `trustState`, `trustFingerprint`, `trustEvidenceCount`, `trustReviewDueAt`, and `trustUpdatedAt` fields. These can be filtered, sorted, grouped, charted, or composed into Dashboards without copying trust state into Markdown frontmatter.