Dataview Query - All values from a Key, of Tasks of a Child page of Inlinks

[1activegeek]

Things I have tried

Attempted variations on my original query, read through documentation, searched multiple similar types of posts

What I’m trying to do

Attempting to list a table that shows a list of Primary pages, with listing of all values from a key on any of the children pages (inbound linked) of the primary page. I can’t share my actual structure view right now, due to privacy of clients, but I’ll lay out a sample structure here.

Customer A - contains a key:value of active:: true

• Meeting 1 (includes Customer:: Customer A on the page)
  • Contains a line of FR:: FR-123
• Meeting 2 (includes Customer:: Customer A on the page)
  • Contains a task, with an FR item FR:: FR-456

Customer B - contains a key:value of active:: true

• Meeting 3 (includes Customer:: Customer B on the page)
  • Contains a line of FR:: FR-123
• Meeting 4 (includes Customer:: Customer B on the page)

Filtered View Dashboard - Query showing Customer, Last Updated, and FR

• Customer links to the Customer:: fields
• Last Updated is pulling metadata
• FR is the problem piece - I’d like to pull ALL values for Keys of FR (FR::)

Current Query for Dashboard is:

```dataview
TABLE WITHOUT ID file.link as "Customer",file.mday as "Last Updated",filter(filter(file.inlinks, (i) => i.tasks).tasks, (i) => i.FR).FR as "FR"
WHERE active = true
SORT file.mtime Desc
```

I’m expecting to see the table populate similar to the following:

Customer | Last Updated | FR
Customer A | Some Date of file last updated | FR-123, FR-456
Customer B | Some date of file last updated | FR 123

Perhaps on different lines, thats fine, but just a list or collection of those FR values from the inlink files to the main account note.

For further reference - this request builds on a previous post that helped tremendously: Dataview Inline Fields in Tasks not Showing Up