Aggregated table views of notes connected via indirect connected notes

[atomman]

In a note sytem wich consist of diffferent type of notes each in its own folder.

1. customer/customerA.md
2. customer/person.md
3. case/caseA.md
4. daily/case_note.md (metadata with backlink to case)

Different cases are associated with different customers. In each case_note there is always a matadata field caseno with backlink to the case. Customer and persons may by references by backlinks in a case_notes.

Things I have tried

for persons the following simple dataview table.

TABLE customer
FROM [[]]
GROUP BY caseno

What I’m trying to do

1. in a case note I want an aggregated table of alle persons which has been mentioned in case_notes
2. In a person note I want to aggregate cases or customers a person has been associated with in a table view.

[atomman]

I think I got the first one right now.
btw. the person.md files is in a Person folder.

TABLE 
FROM [[]]
GROUP BY filter(file.outlinks, (o) => contains(o.file.folder, "Persons")) as persons

[atomman]

I think I got them.
btw. the person.md files is in a Person folder.

TABLE 
FROM [[]]
WHERE filter(file.outlinks, (o) => contains(o.file.folder, "Persons")) as persons
GROUP BY filter(file.outlinks, (o) => contains(o.file.folder, "Persons")) as persons

table rows.file.link as "link", rows.type as "type"
from [[]]
GROUP BY filter(file.outlinks, (o) => contains(o.file.folder, "sager")) as sager