I ran into another issue with it
Notice how the tasks are grouped by file.name what I want is for all of them to sort by Due Date and have no bearing on file or origin.
Here is my code, I only sort by Due Date
Table without id
regexreplace(Tasks.text, "\[.*$", "") as Task,
meta(Tasks.section).subpath as "Status",
Tasks.due As "Due Date",
Tasks.Project As "Project",
file.link as "File"
From "Projects"
Flatten file.tasks As Tasks
Sort Tasks.due asc
Limit 20
Where !Tasks.completed
