Exclude done task in dataview request with FLATTEN

Help
1

Hello,

I have a dataview table for my todo list for a project using this request :

TABLE task.text as "TODO", task.scheduled as "Schedule",
task.due as "Due Date", task.status as "done"
FROM "02 TASKS" 
WHERE (contains(file.outlinks, [[myproject]))
FLATTEN file.tasks AS task

and I would like to select only not done tasks but I tried several ways to do it :

  • task.status!=‘x’
  • !task.isDone
  • !task.completed

but impossible to find the right way to do it, the answers I found on the forum, dataview documentation and internet use different kind of request without the FLATTEN command and it seems that there solutions dont work here. Do some one as the right wayt ? I find the error retrieved by dataview not really helpfull.

Thanks

2

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