Create advanced Works with: Any AI

Obsidian Dataview Query Examples

Few shot Has example

Create dynamic lists from note properties.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Write Dataview queries for my Obsidian vault. Vault structure and the properties (frontmatter) I use: [VAULT_STRUCTURE_AND_PROPERTIES]. Lists or tables I want to see: [DESIRED_VIEWS]. Dataview plugin version if known: [VERSION]. Syntax can differ across versions; verify in the plugin documentation.

Follow this pattern.
Need: all active projects sorted by due date, as a table.
Query:
TABLE due, status
FROM "Projects"
WHERE status = "active"
SORT due ASC
Explanation: FROM selects a folder or tag; WHERE filters by property; SORT orders; TABLE chooses columns.
Example output (made-up): Project A | 2026-11-01 | active.

For each of my desired views, return a query, an explanation, a small example output, and a note about required properties. Include: tasks due this week from daily notes; notes created in the last 7 days; unlinked notes (orphans) check; notes by tag with counts (GROUP BY); reading list by status; a dashboard that combines queries on a home page; and a query that finds notes missing a required property. Add best practices (consistent property names and types, date formats as YYYY-MM-DD, test queries on a small folder), and troubleshooting steps for empty results. Don't include sensitive information in published notes.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Active projects by due date:
TABLE due, status
FROM "Projects"
WHERE status = "active"
SORT due ASC
Example output (made up): Website redesign | 2026-11-01 | active.
Tasks due this week: TASK FROM "Daily" WHERE !completed AND due <= date(today) + dur(7 days)
Notes missing a required property: LIST FROM "Notes" WHERE !type
Orphans check, reading list by status (GROUP BY status). Use YYYY-MM-DD dates and consistent property names. Verify syntax against the plugin documentation for your version. Best practice: keep property names consistent and test queries on a small folder first; if results are empty, check the folder path, property spelling, and date format before changing the query. Do not publish notes that contain sensitive information.

• dataview