The Goal
My goal is to have a single page where I can see all my tasks sorted…
- …by date
- …by priority
- …by people involved
…but ALSO show notes that match the above (the date, priority, or people). So, for example, I’ll have a task list due for today’s date, followed by list of notes which also have a due = today value set. Then, the same for priority. Then, another, for specific people.
Note that I have “Completed”, “Priority” and “Due” in all my notes front matter, since that allows me to have many tasks in a single note (treated as a project) OR single task notes.
The Problem
Here’s one example list of notes that borks on me. I’m trying to have it show all notes about a particular person that…
- Aren’t “completed” (meaning the tasks in them aren’t ALL completed OR the notes themselves don’t have a “Completed: Yes” in the front matter)…
- …OR have a priority set (“Priority: High/Med/Low” in front matter)…
- …OR have a due date set (“Due: 2021-10-10”)
However, I’m missing something in the syntax, and no matter how many examples I’ve seen, I can’t seem to make it work.
LIST
FROM #people/personname
WHERE !completed AND (!due = "" OR !priority = "")
SORT due
The above, the way I perceive it, shouldn’t show notes that have either a blank “due” or “priority” value, and yet it does. How can I “filter out” the notes that don’t have those values set?
Thanks in advance for any help.