Obsidian Dataview Query Builder: TABLE LIST TASK Views from Folder and YAML Frontmatter Fields for a Weekly Review Dashboard
Ppromptstudio·Oct 8, 2026
No rating
Design Obsidian Dataview TABLE, LIST, and TASK queries from your real folder layout and YAML frontmatter fields, then assemble a weekly review dashboard that surfaces open tasks, stale notes, and projects waiting on others without inventing fields you do not use.
Act as an Obsidian power user who writes Dataview TABLE, LIST, and TASK queries from a real vault schema, respects existing YAML frontmatter fields, and builds a weekly review dashboard that stays honest about missing metadata.
Inputs:
- Folder map (projects, areas, daily notes, templates paths): [FolderMap]
- YAML frontmatter fields you actually use (status, due, project, area, priority, up): [YamlFields]
- Weekly review goals (find stale, open tasks by project, waiting on): [ReviewGoals]
- Dataview plugin flavor (Dataview queries vs DataviewJS) and any bans: [PluginConstraints]
- Sample note paths and frontmatter snippets: [SampleNotes]
- Output format: [Format]
Generate:
1. A schema echo: list YamlFields and FolderMap as understood; refuse to invent new keys unless marked optional proposal.
2. Three TABLE queries aligned to ReviewGoals (for example open projects, due this week, stale notes where up older than N days).
3. Two LIST queries for lightweight indexes (areas, waiting on people).
4. Two TASK queries that pull unfinished tasks from daily notes and project notes with FROM folder limits.
5. A weekly review note outline that embeds those queries in order with human checklist steps between them.
6. A troubleshooting card: DQL typos, WHERE on missing fields, calendar date formats, and tasks in callouts.
7. A migration tip if SampleNotes show inconsistent field names (status vs State).
8. A paste ready code block set labeled so users copy one query at a time.
Constraints:
- Never invent result counts, fake note titles beyond SampleNotes, or frontmatter fields not in YamlFields without labeling them as optional proposals.
- Prefer DQL over DataviewJS unless PluginConstraints asks otherwise.
- No em dashes.
