Dataview plugin snippet showcase

paoloap, if you want to only show notes that have tasks associated with them, then you can add a WHERE clause to the query:

```dataview
TABLE
		join(choice(file.tasks.completed, "●", "○"), "") as status
FROM
		#current_project
WHERE
		file.tasks
```

This will only return notes that have tasks in them.

Should you need to find notes that don’t have tasks in the future, you can negate the WHERE clause as follows:

WHERE
    !file.tasks

The ! character means not, so you’re looking for note where there is not any tasks.

3 Likes