Hello, i’m French user (sorry for my english) and i need your help
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 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
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
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) 2023-10-15 #Fred
Etablissement de la proposition commerciale 2023-10-15 #Fred
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))
2023-10-28 #User1
2023-10-15