Given that you’ve got multipleWin, 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]]")
```
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.
Thank you!!! I struggled with this for sooooo long… you are a genius.
Well, actually I’m a novice
I have learnt a lot about dataview, but have not grasped the FLATTEN concept. Where might be the place to learn it from a beginner point of view?