Inline fields with a value

[dandobos]

Hi there. I have a dataview query which is:

TABLE Win as "Wins"
WHERE contains("Win","") and file.ctime > (date(now) - dur(1 day))

This is picking up all inline mentions of Win::

However it shows all files I created yesterday. I just want it show files which I created yesterday that have a Win.

Thank you for your help.

[mnvwvnm]

For files created yesterday and with values in the field Win, maybe this:

TABLE Win as "Wins"
WHERE Win AND file.cday = date(yesterday)

[dandobos]

Amazing. Thank you :)