Question: Filter query WHERE certain field contains a string of text

[jk8104]

Hello! Seeking some help as a complete novice beginning to leverage the dataview plugin. I have notes for "people" where I keep metadata concerning specific individuals that come up in entries, meeting notes, etc. I'm trying a new workflow where I create a note file for meeting notes, which stores metadata about the meeting and my notes for the meeting. One field on the meeting note file is "Participants::". I'd like to set up a TABLE query on a particular individual's "people" file that returns any meeting in which their name shows up in the Participants:: field (currently, I may list multiple participants in the field, comma-separated). As info, the person's name is also the file.name of my "people" file for that person i.e. [[John Smith]] is the name of a "people" file which has John Smith's information. Thank you in advance! And thanks for the amazing plugin!!!

[jk8104]

I was able to find an answer for myself. This seems to be working:

dataview TABLE summary AS "Summary" FROM #Meeting_Notes WHERE contains(Participants, this.file.link)

[blacksmithgu]

That should work, yes.

[stefnestor]

Huzzah for top-of-DuckDuckGo results 🎉 .

For future searchers, you can expand this answer, e.g. with files

- AREAs.md
- AREA data.md

where AREA data.md contains Dataview inline reference

parents:: [[home]], [[AREAs]]

then under AREAs.md (Gotcha: don't put [[AREAs]] in quotes.)

```dataview
TABLE parents
FROM ""
WHERE  contains(parents,[[AREAs]])
```

with results