๐ Project Command Center
Overview
This dashboard automatically tracks all active and upcoming projects in your vault. To add a project here, use the
type: projectproperty in your note.
๐ฅ High Priority & Overdue
Immediate Action Required
Projects that are either High Priority or have passed their due date.
TABLE
status as Status,
priority as Priority,
due_date as "Due Date",
area as Area
FROM "Projects"
WHERE type = "project"
AND status != "โ
completed"
AND (priority = "๐ฅ high" OR due_date < date(today))
SORT due_date ASC๐ข Active Projects
Current Workstream
All ongoing projects currently in progress.
TABLE
priority as Priority,
due_date as "Due Date",
area as Area
FROM "Projects"
WHERE type = "project"
AND status = "๐ข active"
AND priority != "๐ฅ high"
SORT due_date ASC๐ก On Hold / Backlog
Future & Paused
Projects waiting for resources or a start date.
TABLE
status as Status,
priority as Priority,
area as Area
FROM "Projects"
WHERE type = "project"
AND (status = "๐ก on-hold" OR status = "backlog")
SORT priority DESCโ Recently Completed
Accomplishments
Last 10 finished projects.
LIST
FROM "Projects"
WHERE type = "project" AND status = "โ
completed"
SORT file.mtime DESC
LIMIT 10