I need a dataview/dataviewjs statement for my tasks,
I want all uncompleted Tasks in a table from files with specific tags. I want that all the Tasks are orderd by their due and have a link to the file.
I found the following code somewhere in the forum, but i cant filter the completed.
table without ID regexreplace(Tasks.text, "\[.*$", "") AS Task, Tasks.due AS "Due Date", file.link AS "File" from #daily or #project/activ or #subject/activ WHERE file.tasks FLATTEN file.tasks AS Tasks sort Tasks.due ASC