Display open tasks in a Dataview-Table

[New]

I found this post by you @holroy:

Override or add latest data from inline fields to dataview

You’re welcome ## What I currently get ```dataview TABLE WITHOUT ID item.name as Name, item.bday as Bday, item.profession as Job, item.email as Email, item.update as Updated WHERE file = this.file FLATTEN file.lists as item WHERE item.name SORT item.name ASC, item.update ASC ``` ## What I want ```dataview TABLE nonnull(rows.item.bday)[0] as Bday, nonnull(rows.item.profession)[0] as Job, nonnull(rows.item.email)[0] as Email, nonnull(rows.item.update)[0] as Updated WHE…

I tried the nonnull and it worked! No idea why, but I’ll take it. I guess it returns the array but only the value from on position 0?

Now I just need to get the embed to work.

```dataview
TABLE WITHOUT ID
nonnull(rows.file.link)[0] as Project, 
rows.OpenTasks.text as "Open Tasks", 
nonnull(rows.Urgency)[0] as Urgency, 
nonnull(rows.DueDate)[0] as Date,
nonnull(rows.Responsible)[0] + "<br>" + nonnull(rows.Department)[0] as "Responsibel and Department"

FROM "Projects"
WHERE file != this.file
WHERE Completed = False and Limbo = False 

FLATTEN file.inlinks.file.tasks as AllProjectTasks
FLATTEN filter(AllProjectTasks, (task) => !task.completed) as OpenTasks

group by file.link
```

Edit: I have noticed that the project disappears if there are no more open tasks, which should not happen (I think) because of my WHERE Completed = False and Limbo = False. As long as none of these are ticked in properties the project should be displayed in the dataview table. Am I wrong in this assumption?