๐Ÿš€ Project Command Center

Overview

This dashboard automatically tracks all active and upcoming projects in your vault. To add a project here, use the type: project property 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