m-dwyer / obsidian-vault-template Goto Github PK

Hi, first of all thanks for making this. It's very helpful in seeing how a workflow can be built using the dataview plugin.

One issue I ran into is that the queries in the weekly planner did not return any data. Several of the queries filter on "" in the WHERE clause but that did not work for me at all. After some troubleshooting and tinkering it looks like the WHERE clause has to filter on Nil instead, but this isn't in the docs. I opened this issue with the dataviewer maintainer to get clarification on filtering on Nil. blacksmithgu/obsidian-dataview#67

Also the Assigned tasks query in the weekly template includes this in the filter:

assignedDate <= date({{sunday:gggg-MM-DD}}) and
assignedDate >= date({{monday:gggg-MM-DD}})

which also returned zero results.

When I changed it to this it worked:

assignedDate >= date({{sunday:gggg-MM-DD}}) and
assignedDate <= date({{saturday:gggg-MM-DD}})

What was happening in the original is that, since today (as I write this) is a Monday March 29th, the first query template was generating this in the generated weekly note:

assignedDate <= date(2021-03-28) and
assignedDate >= date(2021-03-29)

which of course didn't work.

Anyway thanks for making this vault it has been very very helpful in seeing the flow and possibilities!