Given that you’ve got multiple Win
, and you want to check something against each and every one of them, you need to FLATTEN
the list first.
So given this base data and query:
Win:: [[Mark]] created spreadsheet X
I also have many [Win:: inline fields on that page]
Win:: Not a win
```dataview
TABLE aWin, file.mtime as "Modified"
WHERE this.file.name = file.name
FLATTEN Win as aWin
WHERE contains(aWin, "[[Mark]]")
```
I got this result:
Don’t matter the first WHERE
clause, as I use that to limit my test to this file. The important bit is the FLATTEN Win as aWin
, which allows for every list item in that list to referenced as aWin
. Which then is used both in as a column, and in the last WHERE
clause to check if it contains the [[Mark]]
reference.