Review Calendar

Overdue Reviews

TABLE type, status, criticality, business_owner, next_review
FROM ""
WHERE !contains(file.path, "99 Archive") AND next_review AND next_review < date(today)
SORT next_review ASC

Due in the Next 90 Days

TABLE type, status, criticality, business_owner, next_review
FROM ""
WHERE !contains(file.path, "99 Archive") AND next_review AND next_review >= date(today) AND next_review <= date(today) + dur(90 days)
SORT next_review ASC

All Scheduled Reviews

TABLE type, status, criticality, business_owner, implementation_state, next_review
FROM ""
WHERE !contains(file.path, "99 Archive") AND next_review
SORT next_review ASC, type ASC

Objects Without Next Review Date

TABLE type, status, criticality, business_owner, implementation_state
FROM ""
WHERE !contains(file.path, "99 Archive") AND type AND !next_review AND status != "retired" AND status != "closed" AND status != "dismissed"
SORT criticality DESC, type ASC, file.name ASC