Things I have tried
In my daily note I want to have a dataview, of all the tasks I completed (just) today.
So here is my dataview:
TABLE WITHOUT ID
regexreplace(Tasks.text, "\[.*$", "") AS Tasks
WHERE file.tasks FLATTEN file.tasks AS Tasks
WHERE Tasks.completed
WHERE Tasks.completion = this.file.name
SORT Tasks.to DESC
but the result shows nothing:
As you can see, my daily notes have the format YYYY-MM-DD. When I complete a task, I annotate a inline-metadata like [completion:: YYYY-MM-DD].
In the following dataview, I get the correct result, so I assume the failure in the code above hides in that line: “WHERE this.file.name = Tasks.completion”
TABLE WITHOUT ID
regexreplace(Tasks.text, "\[.*$", "") AS Tasks,
Tasks.link AS "created",
Tasks.completion AS "completion "
WHERE file.tasks FLATTEN file.tasks AS Tasks
WHERE Tasks.completed
SORT Tasks.to DESC
Can anybody help me with that?
Thanks in advance!
Silias