A problem in filter result using where

[hsayed21]

Hi There,

page#1 contains some tasks and includes All tag #All

page#1

• 01_overview
• 02_datatype
• 03_control statements

when adding query

table file.tasks.completed from #All 
where file.tasks.completed = true

It should show all completed tasks, But it appears Dataview: Query returned 0 results.

Please solve, because I want to calculate the percentage of the tasks that have been completed

to simulate this query to make progress bar for tasks

And I wish to add a nested query feature

[M-bot]

Using flatten you can do the following to get a list of completed tasks

table task
flatten file.tasks as task
where task.completed = true

If you want to calculate a value though you'll want to look at javascript api