Feature Request: Tasks should be filterable on the completed state

[strich]

A common scenario (if not the most common) when gathering tasks using dataview is likely to be able to pull all tasks that remain incomplete. It would be ideal to be able to do something like the following to filter out tasks that aren't complete:

task from ""
where !task.complete
sort file.day desc

[blacksmithgu]

This has been on my TODO list forever since it's conceptually simple, my task query implementation is just a hack. Will improve.

[channingwalton]

This would be awesome. Is there a workaround in the meantime?

[Zyrohex]

This would be a great addition! Hope to see it implemented soon.

[blacksmithgu]

I have good news and bad news. The good news is this is now possible; the bad news is you need to write a tiny bit of javascript for it:

```dataviewjs
dv.taskList(dv.pages("#projects").file.tasks.where(t => !t.completed));
```

[channingwalton]

cool, how can I search in every note in my vault?

[clotodex]

cool, how can I search in every note in my vault?

With "". dv.pages works like sources in dataview. You need to quote it though - so '""' (single-tick, quote, quote, single-tick)

dv.taskList(dv.pages('""').file.tasks.where(t => !t.completed));

[breach78]

I have good news and bad news. The good news is this is now possible; the bad news is you need to write a tiny bit of javascript for it:

```dataviewjs
dv.taskList(dv.pages("#projects").file.tasks.where(t => !t.completed));

Thank you!
Is it possible to list it in modified order?

[wenlzhang]

Is it possible to sort the tasks based on file name?

[danielhauck]

You mean for tasks that are appearing in a file? Like give me all from "Project X"?

```dataviewjs
const targetPage = "Project X"

 

dv.taskList(
    dv.array(
        dv.page(targetPage).file.tasks
    ).where(t => !t.completed)
)
```

You just need to 'cast' it as a dataview array.

[wenlzhang]

Thanks for the prompt reply! @danielhauck Sorry for not being clear about what I am trying to achieve. Now I will elaborate it as follows.

First, I may query all tasks from files within a folder with something like:

dv.taskList(dv.pages('"Daily note"')
	.file.tasks
	.where(t => !t.completed)
	)

This lists all uncompleted tasks from files within the folder Daily note. However, I am not sure how are the task files sorted. Therefore, I would like the tasks to be sorted based on the file name where they come from, e.g. Note A, Note B, Note C, etc. Each of such a note/file consists of a series of uncompleted tasks.

I tried the following options (without knowing if the syntax is correct or not :-(, however), but neither of them worked for me.

dv.taskList(dv.pages('"120-Daily note"')
	.file.tasks
	.where(t => !t.completed)
	.sort(p => p.file.name, 'asc')
	)

dv.taskList(dv.pages('"120-Daily note"')
	.file.tasks
	.where(t => !t.completed)
	.sort(t => t.file.name, 'asc')
	)

Of course, it would be great if the tasks from individual files/notes can also be somehow sorted, e.g., based on task description.

I also tried your code, and it gives the following error message:

const targetPage = "Daily note"

dv.taskList(
    dv.array(
        dv.page(targetPage).file.tasks
    ).where(t => !t.completed)
)

Evaluation Error: TypeError: Cannot read property 'file' of undefined
    at eval (eval at <anonymous> (eval at <anonymous> (app://obsidian.md/app.js:1:1212458)), <anonymous>:5:28)
    at DataviewInlineApi.eval (eval at <anonymous> (app://obsidian.md/app.js:1:1212458), <anonymous>:12129:33)
    at evalInContext (eval at <anonymous> (app://obsidian.md/app.js:1:1212458), <anonymous>:12129:49)
    at DataviewJSRenderer.eval (eval at <anonymous> (app://obsidian.md/app.js:1:1212458), <anonymous>:12591:17)
    at Generator.next (<anonymous>)
    at eval (eval at <anonymous> (app://obsidian.md/app.js:1:1212458), <anonymous>:26:71)
    at new Promise (<anonymous>)
    at __awaiter (eval at <anonymous> (app://obsidian.md/app.js:1:1212458), <anonymous>:22:12)
    at DataviewJSRenderer.render (eval at <anonymous> (app://obsidian.md/app.js:1:1212458), <anonymous>:12583:16)
    at DataviewJSRenderer.eval (eval at <anonymous> (app://obsidian.md/app.js:1:1212458), <anonymous>:12578:28)

[blacksmithgu]

Ah, this is a short-coming of the dv.taskList() implementation; I need to add some configuration to be able to decide how you sort tasks and files. @wenlzhang Would you mind filing an issue with the contents of your comment for tracking?

[wenlzhang]

That's great news! Looking forward to that! @blacksmithgu This feature request can be found in the following issue:
#407

[rickybright]

Is there a way that instead of telling it to look at a file with dv.pages I can have it look at all the files in a folder?

[blacksmithgu]

You still use dv.pages, just providing the path to the folder: dv.pages('"path/to/folder/"').

[rickybright]

Ah, I was just using dv.pages("x/y/z") instead of dv.pages('"x/y/z"').

[blacksmithgu]

Yay, tasks can now be filtered on completed!

TASK WHERE !completed

You can also do a fair bit other stuff with them, like using the text property (which contains their text), or subtasks (which contains a list of subtasks), and so on!

[blacksmithgu]

Thanks for @sheeley for implementing this functionality.

[uwidev]

Does this functionality extend to DataView Table queries? I'm trying to count all completed tasks onto a table as a proof of concept. I later want to count completed completed tasks per folder. For some reason I can't get any tasks to query.

Here's my query

TABLE length(rows) as "Count Completed Tasks"
FROM "Test"
WHERE completed
Flatten file.tasks
GROUP BY file.folder

Running it barebones and just trying to query completed tasks without fancy groupings doesn't yield any results either. Running the query as a Task rather than a Table works, however.

This is how my notes are set up, in their own folders as follows.

[sheeley]

The task list and table depend upon different implementations internally. I could see this being interesting.

@blacksmithgu think there should be a task table?

[blacksmithgu]

@blongty @sheeley The correct move here is to (1) allow FROM statements to select tasks instead of files, and (2) implement task renderering support so that they work automatically in both list views and table views.

This is something @sheeley can look into in the short-medium term if he has time / interest.

[sheeley]

@blacksmithgu happy to. Thoughts on the syntax?

• task table foo, bar from ...
• table foo, bar as task from
• table foo, bar from tasks

And for the functionality, would you expect a single task per row? Or would it be possible to render a task per cell? I could see value in the latter.

[blacksmithgu]

For the syntax, I'm thinking TABLE foo, bar FROM TASKS <source query>; this particular syntax is mainly because we can extend it easily to support sections and other metadata (FROM SECTIONS ...).

I think the default would be one task per row, allowing "task lists" via a GROUP BY.

[acetuk]

Does this functionality extend to DataView Table queries? I'm trying to count all completed tasks onto a table as a proof of concept. I later want to count completed completed tasks per folder. For some reason I can't get any tasks to query.

Here's my query

TABLE length(rows) as "Count Completed Tasks"
FROM "Test"
WHERE completed
Flatten file.tasks
GROUP BY file.folder

Running it barebones and just trying to query completed tasks without fancy groupings doesn't yield any results either. Running the query as a Task rather than a Table works, however.

This is how my notes are set up, in their own folders as follows.

Did you find a way to count the tasks? I am trying to do the same thing in a standard dataview query where I want to report the number of open tasks and potentially exclude results returned from pages that have no tasks.

[KaynaL-MT]

this also worked for me:

TASK
WHERE task != completed

[martijnvangils]

task where !completed works as well