Things I have tried
I have been trying to make my tasks show up as a table, and I found this awesome thread:
Create dataview table of multiple tasks within notes - Help - Obsidian Forum
But I cannot figure out how to exclude the completed tasks. I have tried a few different options, and none seem to work. This is what I have so far:
TABLE WITHOUT ID regexreplace(Tasks.text, "\[.*$", "") AS Task, choice(Tasks.completed, "completed", "not done") AS Status, Tasks.completion AS "Completion Date", Tasks.due AS "Due Date", Tasks.created AS "Created Date", Tasks.priority AS "Priority", file.link AS "File" FROM "05.WORK" and -"00.META" and -"99.ARCV" and -"05.WORK/05c1.AHD" FLATTEN file.tasks AS Tasks WHERE file.tasks AND != ✅
Any help would be much appreciated.