3181d0ed88
- 01 Projects/Dashboard.md: live Dataview dashboard (active, recent, by client, stale, production) - 01 Projects/Projects.base: Obsidian Bases view with 4 layouts (table, by client, active, cards) - Templates/Daily Template.md: upgraded — added Dataview queries, removed broken Work Tasks link - Templates/Weekly Review Template.md: new — fractal journaling weekly review with auto-queries Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
1.2 KiB
1.2 KiB
| name | type | tags | updated | |||
|---|---|---|---|---|---|---|
| Project Dashboard | dashboard |
|
2026-04-14 |
Project Dashboard
Live view — powered by Dataview. For static table see Projects Index.
Active Projects
TABLE client, tech, dateformat(file.mtime, "yyyy-MM-dd") AS "Last Updated"
FROM "01 Projects"
WHERE status = "active" AND type != "dashboard"
SORT file.mtime DESC
Recently Changed (Last 7 Days)
TABLE client, dateformat(file.mtime, "yyyy-MM-dd HH:mm") AS "Modified"
FROM "01 Projects"
WHERE file.mtime >= date(today) - dur(7 days) AND type != "dashboard"
SORT file.mtime DESC
Projects by Client
TABLE WITHOUT ID file.link AS "Project", tech, status
FROM "01 Projects"
WHERE client AND type != "dashboard"
SORT client ASC, file.name ASC
Stale — No Update in 30+ Days
TABLE client, status, dateformat(file.mtime, "yyyy-MM-dd") AS "Last Touch"
FROM "01 Projects"
WHERE status = "active" AND file.mtime < date(today) - dur(30 days) AND type != "dashboard"
SORT file.mtime ASC
Production / Deployed
TABLE client, deploy, url
FROM "01 Projects"
WHERE status = "production" AND type != "dashboard"
SORT client ASC