104 lines
1.4 KiB
Markdown
104 lines
1.4 KiB
Markdown
---
|
|
title: "Dashboard Query Block"
|
|
status: "active"
|
|
folder: "000-shit_admin"
|
|
tags: [dashboard, dataview, template]
|
|
created: "2026-07-29"
|
|
updated: "2026-07-29"
|
|
version: "1.0.0"
|
|
---
|
|
|
|
# Dataview Query Snippets
|
|
|
|
Reusable Dataview blocks. Paste into any note.
|
|
|
|
---
|
|
|
|
## Active Tasks
|
|
|
|
```dataview
|
|
TABLE priority, due, owner
|
|
FROM ""
|
|
WHERE contains(tags, "task") AND status = "active"
|
|
SORT priority ASC, due ASC
|
|
```
|
|
|
|
## Today's Daily Note
|
|
|
|
```dataview
|
|
LIST
|
|
FROM "01-logs/daily"
|
|
WHERE date = date(today)
|
|
```
|
|
|
|
## Recent Edits
|
|
|
|
```dataview
|
|
LIST
|
|
FROM ""
|
|
WHERE status != "archive"
|
|
SORT updated DESC
|
|
LIMIT 10
|
|
```
|
|
|
|
## Recent Archives
|
|
|
|
```dataview
|
|
LIST
|
|
FROM ""
|
|
WHERE status = "archive"
|
|
SORT updated DESC
|
|
LIMIT 10
|
|
```
|
|
|
|
## Inbox Count
|
|
|
|
```dataview
|
|
LIST
|
|
FROM "00-inbox"
|
|
WHERE status = "draft"
|
|
```
|
|
|
|
## All Handoffs
|
|
|
|
```dataview
|
|
TABLE from, to, date
|
|
FROM "05-handoffs"
|
|
SORT updated DESC
|
|
```
|
|
|
|
## Research by Tag
|
|
|
|
```dataview
|
|
LIST
|
|
FROM "02-notes"
|
|
WHERE contains(tags, "research")
|
|
SORT updated DESC
|
|
```
|
|
|
|
## Tasks by Owner
|
|
|
|
```dataview
|
|
TABLE priority, due, status
|
|
FROM ""
|
|
WHERE contains(tags, "task") AND owner = "stateofshit"
|
|
SORT priority ASC
|
|
```
|
|
|
|
## Tasks Due Soon
|
|
|
|
```dataview
|
|
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
|
|
|
|
```dataview
|
|
TABLE priority, due, owner
|
|
FROM ""
|
|
WHERE contains(tags, "task") AND status = "active" AND due AND due < date(today)
|
|
SORT due ASC
|
|
``` |