Restricting dataview queries to notes that have specified fields

[excalibud]

Things I have tried

Looking at dataview documentation and googling.

What I’m trying to do

I want to include a WHERE clause that specifies that a file contains a given field. e.g. something like

TABLE rating
WHERE contains(file, “rating”)

The above doesn’t work since the file object only contains implicit fields. I think the above should work if instead of file the input was some object that contains fields corresponding to the page’s dataview fields. However I haven’t been able to find any such object described in the dataview documentation.

[scholarInTraining]

WHERE fieldName should do the trick e.g. WHERE rating in your example.

[excalibud]

Simple! Thanks for that.