Inline fields challenge

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.

2 Likes