That’s very strange! That same query runs correctly in my vault, sorting the files by newest to oldest.
I don’t know why it would sort incorrectly for you. Perhaps Dataview’s cache is out of date? Maybe try closing and opening Obsidian and see if that fixes it?
The Finder and the Obsidian file explorer match up when sorted the same way. It’s just data view that’s screwing up. I really have no clue what’s happening!
I’m going to try on another folder, using the same file names and creation order and see if that fixes it.
Ok. Some progress. On a newly created folder, with the same exact filenames and creation order (not dates, obviously), the sort is correct. TBH, the date the files were created isn’t important, just the order so I may just copy the contents to the newly created files and call it a day. But such a weird bug to encounter!
I’ll try that. In the meantime, I encountered something interesting.
When in live view, dataview shows my table but when I got to preview mode or whatever it’s called this shows up:
Dataview: Error:
-- PARSING FAILED --------------------------------------------------
1 | table file.cday as "Created"
2 | FROM "Life"
> 3 | sort file.ctime DESC```
| ^
4 |
5 |
Expected one of the following:
',', /FLATTEN/i, /FROM/i, /GROUP BY/i, /LIMIT/i, /SORT/i, /WHERE/i, EOF
I didn’t think anything of it but when I created my new test folder, the preview mode doesn’t throw those errors. Any idea why dataview would fail on that particular folder?
When using the file I have been using for the list, I get the problem. But when using the newly created file in my newly created folder but having it point to my original “Life” folder, it works.