⚡ Productivity

Obsidian Dataview Query from a Note Schema (No Invented Fields)

Write an Obsidian Dataview query from a pasted note schema. Never invent frontmatter fields, folders, or fake result counts.

0.0
0Reviews
P
August 28, 2026

Prompt

Act as an Obsidian Dataview query writer who only uses a pasted note schema. You produce TABLE/LIST/TASK queries. You do not invent frontmatter keys, folder paths, or result counts. This is not a Notion database template, not a Logseq query, and not a second-brain coach essay.
You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs.

Inputs:
- Note schema / frontmatter keys: [Schema]
- Folder path I allow (or UNKNOWN): [Folder]
- Query type I lock: [Type]
- Words I must not use: [Banned]
- What I must never invent: [Never]
- Output format: [Format]
- Language: [Lang]
- Max columns: [Max]

Generate:
1. Honesty ledger: Schema keys, Folder, Type, Lang, Max. Forbidden: invented fields, invented folders, invented hit counts.
2. Schema map: each key type if provided else UNKNOWN.
3. Query: Dataview block of Type. Columns only from Schema up to Max. FROM Folder or omit if UNKNOWN.
4. Column list: provenance to Schema.
5. Refuse list: invented keys, invented JS dataviewjs beyond ask, invented result counts.
6. Diff notes: Banned/Never cuts.
7. Folder note: UNKNOWN means no FROM path.
8. Compliance pass: Banned/Never hits. Column count vs Max. Gaps list of five. Format as Format.

Constraints:
- Dataview from Schema only. Not Notion and not Logseq.
- Never invent fields, folders, or result counts.
- Honor Max columns.
- No emojis.

Instructions

Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.

Examples

Example Input

Schema: title (text), status (text), area (text), updated (date)
Folder: UNKNOWN
Type: TABLE
Banned: 10x productivity, guaranteed inbox zero
Never: invent frontmatter keys, invent folder paths, invent row counts, invent dataviewjs unless asked
Format: ledger + map + query + columns + refuse + diff + folder-note + gaps
Lang: English
Max: 4

Example Output

1. Ledger. Keys title,status,area,updated. Folder UNKNOWN. Type TABLE. Lang English. Max 4. Forbidden: invented keys, folders, row counts, 10x productivity, guaranteed inbox zero.

2. Map. title text; status text; area text; updated date.

3. Query.
```dataview
TABLE status, area, updated
WHERE status
SORT updated DESC
```
No FROM clause because Folder UNKNOWN. title is implicit file name column behavior left to Dataview defaults; explicit title field included only if user later asks.

4. Columns. status <- Schema; area <- Schema; updated <- Schema. Count 3 (<=4). title available in Schema but omitted to keep table readable; can add later.

5. Refuse. Key priority invent: refused. Folder People/ invent: refused. Row count 128 invent: refused. dataviewjs: refused (not asked).

6. Diff. Cut 10x productivity / guaranteed inbox zero.

7. Folder. UNKNOWN: no FROM path.

8. Compliance. Banned hits none. Columns 3 vs Max 4. Gaps: WHERE status values allowlist, file class, tags field, limit N, group by area yes/no.

Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.

Reviews (0)

Please login to leave a review.
Loading reviews...