1
2
3
4
5

table deadline
FROM #projects/monthly
WHERE file.name != "Project Template" and !hibernating
WHERE completed = null
SORT deadline desc

1
2
3
4
5

table deadline
FROM #projects/weekly
WHERE file.name != "Project Template" and !hibernating
WHERE completed = null
SORT deadline asc

1
2
3
4
5

table deadline
FROM #projects
WHERE file.name != "Project Template" and hibernating
WHERE completed = null
SORT deadline desc

1
2
3
4

table archived
FROM #projects/archived
WHERE file.name != "Project Template"
SORT completed desc

1
2
3
4

table completed
FROM #projects
WHERE file.name != "Project Template" AND completed != null
SORT completed desc