Query type: TABLE
Active project dashboard
Show active project notes, hide archived work, and sort the next commitment by due date.
Required fields: status, due
```dataview
TABLE file.link AS "Project", status, due
FROM "Projects"
WHERE status != "archived"
SORT due ASC
```
How to customize: Change Projects to your project folder and replace status or due with your own frontmatter fields.
Query type: TABLE
Content calendar
Track drafts, planned posts, videos, or newsletters that still need publishing.
Required fields: stage, publish, channel
```dataview
TABLE file.link AS "Content", stage, publish, channel
FROM "Content"
WHERE stage != "published"
SORT publish ASC
LIMIT 12
```
How to customize: Use stage values such as idea, draft, editing, scheduled, and published.
Query type: TABLE
Meeting notes that need follow-up
Find meeting notes where a follow-up field is not marked done.
Required fields: date, followup, project
```dataview
TABLE date, project, followup
FROM "Meetings"
WHERE followup != "done"
SORT date DESC
```
How to customize: If you use a boolean field, change the condition to followup = false.
Query type: TABLE
Book notes by reading status
Build a reading tracker from book notes and sort unfinished reading by status.
Required fields: author, status, rating
```dataview
TABLE author, status, rating
FROM "Reading"
WHERE status != "finished"
SORT status ASC
```
How to customize: Add started or finished date fields if your reading notes include them.
Query type: TABLE
Notes missing metadata
Find notes that still need a status field before they can appear in dashboards.
Required fields: status
```dataview
TABLE file.folder, file.mtime
FROM "Projects"
WHERE status = null
SORT file.mtime DESC
```
How to customize: Replace status with any required field you want to audit, such as owner, topic, or priority.
Query type: TABLE
High priority work
List important notes or projects where priority is 3 or higher.
Required fields: priority, due, status
```dataview
TABLE priority, due, status
FROM "Projects"
WHERE priority >= 3
SORT priority DESC
LIMIT 20
```
How to customize: Change the threshold if your vault uses 1-5, low-medium-high, or another priority scale.