Dataview File List Query for Task with no Scheduled date and specific TAG

What I’m trying to do

Hello, i’m French user (sorry for my english) and i need your help :slight_smile:

In a folder called “01.PROJECTS IN PROGRESS” I have numerous files corresponding to customer projects. In each file in the “01.PROJECTS IN PROGRESS” folder, I have lists of tasks, some of which are scheduled and assigned to collaborators using tags.

  • Exemple :hourglass_flowing_sand: 2023-10-28 #User1

I have lists showing all tasks by collaborator, grouped by scheduled task date. When a task on a list is completed, I note its completion and set a programmed date for the next task, then tag a collaborator to assign the task and make sure it’s done by the programmed date.

Sometimes I forget to associate either a scheduled date or to tag a collaborator, which delays or even forgets the task :frowning:

I’d like a list of files that don’t contain at least one task programmed with a collaborator’s tag.

Things I have tried

I try this :

list 
from "01.PROJETS EN COURS"
WHERE
	!completed
	AND	text !="#Fred"
	AND !Tasks.Scheduled
GROUP BY file.link

Thanks for your help :slight_smile:

Here are some queries which might help you on your quest to fix tasks not having a scheduled date or a collaborator.

## All tasks
```dataview
TASK
WHERE file.folder = this.file.folder
GROUP BY file.link
```

## Fix these tasks
```dataview
TASK
WHERE file.folder = this.file.folder
WHERE !completed
  AND (!scheduled or !tags)
GROUP BY file.link
```

## Using LIST query

```dataview
LIST
WHERE file.folder = this.file.folder
FLATTEN file.tasks as task
WHERE !task.completed
  AND (!task.scheduled OR !task.tags)
GROUP BY file.link
```

Not sure if you really need to use GROUP BY file.link in either of these queries, so do try them without that as well. Note that TASK queries always allows linking back to the originating files by clicking on the task text.

You might also want to look into variants over !contains(tags, "#Fred") if you want the tags list not to have #Fred in it.

Hello HolRoy
Thank you very much for your reply and your help.
This is exactly what I’m looking for, but I’d like only files that don’t contain at least one task with a scheduled date and tag to be listed.
For example, I would like this file not to appear in the result and this is where I have a problem.

ToDo

  • Préparation du dossier (collecte des informations) :white_check_mark: 2023-10-15 #Fred
  • Etablissement de la proposition commerciale :white_check_mark: 2023-10-15 #Fred
  • Transmission de la proposition :white_check_mark: 2023-10-15 #Fred
  • Relancer Geoffray #Fred :hourglass_flowing_sand: 2023-11-09
  • Prendre RDV

Thanks again for your help

The query should only list files which doesn’t have either the tag or the scheduled date.

But you’re wanting to remove all tasks from a file, if some criteria? I don’t quite get what you’re saying here. Please show some more examples of files/tasks to be included, or to be ignored. (Preferably also with the expected output (even if that is manually written for now))