Only show item in data view if it appears under a specific header

[Mosquito]

What I’m trying to do

I have two main pages:

A “Person” template that I use to keep notes about a person, links to meetings, and if they are a direct report links to one on ones. The meeting section has a data view that looks like this:

```dataview
TABLE file.cday as Created, summary AS "Summary"
FROM #meeting AND [[]]
SORT file.cday DESC```

I have a meetings template, that contains an H3 Attendees where I provide a bulleted list of people (linking to their people page) that attended the meeting. It looks something like this on a meeting

### Attendees
- [[Me]]
- [[Bob]]
- [[Alice]]

Question:
On the Person template, can I adjust the dataview query to only show meetings where the person is listed in attendees? As it is now, if I have someone linked in another note, they show up in the meetings dataview results, which is not what I want.

Things I have tried

I know I can embed items doing something like this: ![[2024.09.23#Attendees]], but that’s not exactly what I want. I want to somehow combine the ability to link a note in the dataview to a person, but only when they are an attendee of said meeting.

[Mephi]

Hey there, maybe you could try something like this:

TABLE file.cday as Created, summary AS "Summary"
FROM #meeting
FLATTEN file.lists as A WHERE meta(A.section).subpath = "Attendees" AND contains(A.text, this.file.name)
SORT file.cday DESC