Listing files that ends by specific characters in directory

[LaurentB]

Hi everyone,

Kinda new to Obsidian and I’m loving it. I have a directory with my daily notes and a note where I have questions for each day of the year. I want to automatically retrieve the files in my Spaces /Journal/Dailythat ends with the MM-DD of the file (they are named. YYYY-MM-DD).

Searching the forum, I tried this but it does not work, I have a emoji in my folder name but tried without it, and it still does not work. There is a 2022-02-03 file in the directory.

TABLE file.name AS "File" FROM "Spaces 🔭/Journal/Daily" 
WHERE contains(File, "02-03") 
SORT File DESC 

Thanks for your help,

[andrezgz]

Hi, use the <field name> in dataview queries to filter or sort results, not the "column name":

TABLE file.name AS "File" FROM "Spaces 🔭/Journal/Daily" 
WHERE contains(file.name, "02-03") 
SORT file.name DESC 

[LaurentB]

@andrezgz

TABLE file.name AS "File" FROM "Spaces 🔭/Journal/Daily" 
WHERE contains(file.name, "02-03") 
SORT file.name DESC 

Ahhhhh. So obvious when you say it, I’m wandering how I didn’t that. Thanks a lot for your time and help.