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 :

	AND	text !="#Fred"
	AND !Tasks.Scheduled

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
WHERE file.folder = this.file.folder

## Fix these tasks
WHERE file.folder = this.file.folder
WHERE !completed
  AND (!scheduled or !tags)

## Using LIST query

WHERE file.folder = this.file.folder
FLATTEN file.tasks as task
WHERE !task.completed
  AND (!task.scheduled OR !task.tags)

Not sure if you really need to use GROUP BY 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.


  • 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))

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.