Dataview query using flatten and group by not sorting by date

What I’m trying to do

I’m trying to extract my journal entries of a year which are under a heading called “Journal”. Each day has its on file. I got this working. The thing that doesn’t work is to sort the whole thing by file.cdate descending. Not sure why it doesn’t work

Things I have tried

TABLE
rows.bullets.text as "Journal"
FROM #journal 
FLATTEN file.lists as bullets
WHERE meta(bullets.section).subpath = "Journal" AND file.ctime.year = 2023
SORT file.ctime DESC
GROUP BY file.name

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.