Dataview plugin. File name contains word "report"..How to query it?

[andypassion]

Hi! I have a folder where some files have in their names word “report” , like: “report about health” , “report about sport”. And there are files with different names too in the same folder.
The question:
Is there a way to query all files from that folder that contains word “report” in their names using Dataview plugin?
A made a query but it is not working like i need to…

table tags
from "test folder"
where file.name = "report"
sort rating desc

Thank you!

[mnvwvnm]

Try this:

```dataview
TABLE tags
FROM "test folder"
WHERE contains(file.name, "report")
SORT rating DESC
```

Note: attention to case sensitive. If you have “report” and “Report”, may you need to put this: WHERE contains(file.name, "report") OR contains(file.name, "Report") (or other more simple expression…)

[andypassion]

Fantastic! It works! Thank you very much!!