What I’m trying to do
I am using the following code to grab bullet points from a particular header (## [[Secrets and Clues - Witchlight]]) from a number of pages (filename: WBWYYYYMMDD, all are tagged with #diary)
```dataview
TABLE rows.bullets.text as "Secrets and Clues"
FROM #diary
SORT file.date ASC
FLATTEN file.lists as bullets
WHERE meta(bullets.section).subpath = "Secrets and Clues - Witchlight"
GROUP BY file.link
```
Here are the first three rows of the table:
It works fine, but the in the table returned, the rows are always in the same order. I’m not sure if the sort order is the date the files was created, or the alphabetical order of the page title.
I would like to reverse the sort order of the rows.
Things I have tried
The sort line of the dataview query does nothing. I have tried ASC/DESC. I have tried various of file.date/file.name/file.link and nothing changes the sort order. I don’t even need the sort line.
Is it even possible to sort the table that has been created?
Additional Question
I know the flatten keyword puts all the bullets at the same level. Is it possible to preserve the indentation level? For example, in the second row, Burly is at bullet level 1 and the four lines below are indented at level 2 on the original page. I suspect the limitations of dataview and this particular query technique make this not possible, but if there is someone VERY clever out there with a solution, I would love to hear it.