Is there a way to query notes from a particular date in Obsidian?

[maddyboy]

Is there a way to fetch latest 10 notes sorted by modified date ?

search only provides these options

[Angel]

With dataview:

```dataview
LIST
FROM ""
WHERE date(today) - file.mtime
WHERE file.name != this.file.name
SORT file.mtime DESC
LIMIT 10
```

Works as you need?

Angel

[maddyboy]

@Angel

```dataview
LIST
FROM ""
WHERE date(today) - file.mtime
WHERE file.name != this.file.name
SORT file.mtime DESC
LIMIT 10

@Angel It works, but I use a plugin called “Zoottelkeeper”, which automatically updates index files inside every folder.

So, it shows up those index files also.

Is there a way to exclude certain files ?

I tried

```dataview 
LIST FROM "" WHERE date(today) - file.mtime 
WHERE file.name != this.file.name  
OR "🏷 AREAS 📂" 
OR "🏷 Crypto 🧊" 
SORT file.mtime DESC LIMIT 10 

It does not gives any parse error but does not exclude the files.

[maddyboy]

@Angel Figured it out. This works.

LIST FROM "" WHERE date(today) - file.mtime 
WHERE file.name != this.file.name  
AND file.name != "🏷 AREAS 📂" 
AND file.name != "🏷 Crypto 🧊" 
SORT file.mtime DESC LIMIT 10 

can we use wildcards like

AND file.name != "A*"

where all files starts with A are included ?

[maddyboy]

@Angel

LIST FROM "" 
WHERE file.name != this.file.name
WHERE contains(file.name, "🏷")
SORT file.mtime DESC LIMIT 10

This feteches only files starting with

But, is there something equelent to “does not contain” ?

[Angel]

As you have worked out, specific files and folders can be excluded or targeted. Not sure about wild cards, and not on a device with Obsidian on to be able to test anything, but you might be able to do some filtering with ‘contains’.

Can we use templater to Map new notes automatically?

The following creates an index for any folder that the index note is in without having to localize the query to the folder’s name: ```dataview LIST WHERE contains(file.folder, this.file.folder) SORT file.name ASC WHERE file.name != this.file.name ``` The line… WHERE file.name != this.file.name …removes the self-referencing title of the index file from the index that is produced. Can be removed, of course. Credit to this post. Angel

Angel

[maddyboy]

@Angel Figured out

!contains works

LIST FROM "" 
WHERE file.name != this.file.name
WHERE !contains(file.name, "🏷")
SORT file.mtime DESC LIMIT 10

[Angel]

Was just back at a Mac and about to try to help, but you crossed the line ahead of me. Bravo!

Great it is working for you.

Angel