Projects

📋 Projects

Active

TABLE status, due, up AS "Area", modified
FROM "10-Projects"
WHERE status = "active"
SORT due ASC

On hold

TABLE due, modified
FROM "10-Projects"
WHERE status = "on-hold"

Stale (active, untouched 14+ days)

TABLE modified
FROM "10-Projects"
WHERE status = "active" AND date(today) - date(modified) > dur(14 days)
SORT modified ASC

Done (archive candidates)

LIST
FROM "10-Projects"
WHERE status = "done"