Show a calender that marks all days with uncompleted tasks

Mark days that have unfinished todos¶

[!info]
You'll need to go back to Januray/Februrary 2022 to see the data.

Basic¶

CALENDAR file.day
FROM "10 Example Data/dailys"
FLATTEN all(map(file.tasks, (x) => x.completed)) AS "allCompleted"
WHERE !allCompleted

[!tip]
When you try to write complex calendar queries, write a TABLE query first to make sure your query returns the results you're expecting.

TABLE file.day, allCompleted
FROM "10 Example Data/dailys"
FLATTEN all(map(file.tasks, (x) => x.completed)) AS "allCompleted"
WHERE allCompleted

CALENDAR file.day
FROM "10 Example Data/dailys"
FLATTEN any(map(file.tasks, (x) => x.status = " ")) AS "anyEmpty"
WHERE anyEmpty