Sort tasks, so status “TODO” is on top and status “DONE” is down

[SiliasGH]

Hi,
I want to sort my tasks, so that the status “TODO” on top. My codeblock produces always the other way round.

=> What am I doing wrong or which field do I miss?

Thanks in advance!
Things I have tried

tags include #task
sort by created
sort by done
group by tags
group by folder
group by status

[claremacrae]

What am I doing wrong or which field do I miss?

I've not got very long to reply, and since you haven't shown any tasks and what the sort looks like, I can only guess....

But do this experiment, to learn what is going on:

1. Remove - or comment out with # all sort and group instructions

tags include #task

• All matching tasks are shown, sorted in the Default sort order

2. Then add a first sort by done

tags include #task
sort by done

Observe how

• the tasks are indeed sorted first by status
• and ones with the same status are sorted by Default sort order.

3. Now add group by folder

tags include #task
sort by done
group by folder

Observe how

• the groups are in alphabetical order
• and then the tasks are sorted by status within each group
• and ones with the same status are sorted by Default sort order.

4. You can add reverse to the sort by and group by instructions to reverse their sort orders.

With that, you should be able to experiment and get the result you want.

[SiliasGH]

Thanks, your workflow helped to find it out! :)

[claremacrae]

Great - what query did you settle on?
Could you share it here, to help others...

[SiliasGH]

Sure, I just thought, it was so easy, it won't be necessary to share. Thank you very much for your help and the reminder to share anyways!!!

Here my query, that produced the results I expected:

tags include #task
group by folder
group by status reverse
sort by created

=>

• It was not necessary to group by tags, because I already filtered by tags.
• the reverse grouping of status produced the result, that open task are shown on top
• therefore sort by done (I'm actually not sure, it that is a valid command) was not necessary any more

[claremacrae]

Super. Many thanks.