Projects.md

banner	01 Projects/Common/banner.jpg
id	Projects
aliases
tags	projects
cssclasses
dg-publish	true

🧭 Projects Dashboard

Welcome to your central Project Hub — an overview of all projects, tasks, and notes.

---

Active Projects

table
    Status,
    length(file.tasks) as "Tasks",
    sum(file.tasks.completed) as "Done",
    file.mtime as "Last Updated"
from #projects
where Status != "Completed"
Limit 5
sort file.mtime desc

Tasks

not done
limit 10

---

Completed Projects

table date(file.mtime) as "Completed On"
from #projects
where Status = "Completed"
sort file.mtime desc

Tasks

done
limit 10

---

Upcomming Tasks

task
from "Projects"
where !completed and due and due <= (date(today) + dur(7 days))
sort due asc