shit_in_a_vault/000-shit_admin/dashboard-queries.md

title, status, folder, tags, created, updated, version

title	status	folder	tags	created	updated	version
Dashboard Query Block	active	000-shit_admin	dashboard dataview template	2026-07-29	2026-07-29	1.0.0

Dataview Query Snippets

Reusable Dataview blocks. Paste into any note.

---

Active Tasks

TABLE priority, due, owner
FROM ""
WHERE contains(tags, "task") AND status = "active"
SORT priority ASC, due ASC

Today's Daily Note

LIST
FROM "01-logs/daily"
WHERE date = date(today)

Recent Edits

LIST
FROM ""
WHERE status != "archive"
SORT updated DESC
LIMIT 10

Recent Archives

LIST
FROM ""
WHERE status = "archive"
SORT updated DESC
LIMIT 10

Inbox Count

LIST
FROM "00-inbox"
WHERE status = "draft"

All Handoffs

TABLE from, to, date
FROM "05-handoffs"
SORT updated DESC

Research by Tag

LIST
FROM "02-notes"
WHERE contains(tags, "research")
SORT updated DESC

Tasks by Owner

TABLE priority, due, status
FROM ""
WHERE contains(tags, "task") AND owner = "stateofshit"
SORT priority ASC

Tasks Due Soon

TABLE priority, due, status
FROM ""
WHERE contains(tags, "task") AND status = "active" AND due AND due <= date(today) + dur(7 days)
SORT due ASC

Overdue

TABLE priority, due, owner
FROM ""
WHERE contains(tags, "task") AND status = "active" AND due AND due < date(today)
SORT due ASC