How to sort tasks that show empty values at the bottom?

[wenlzhang]

I have defined some inline fields for managing tasks with Dataview. On the other hand, some tasks do not have such fields, meaning that their values would be null for those fields.

In Dataview, one can sort tasks with something like sort p asc. In this case, how to show tasks that have no priority at the bottom?

I found something like the following for handing things like this for sorting ordinary notes, I suppose:
.sort(i => [i.prio, i.due ?? dv.date("3000-01-01")]) from #456

Considering this, a few other related questions would be:

• Is it possible to sort and group tasks with DataviewJS in a similar way with Dataview?
  • For instance, with Dataview, one can sort and group tasks with something like sort p asc and group by p.
• Is it possible to sort tasks that show those without null priority at the bottom?

[wenlzhang]

The same happens when grouping tasks. It would be great if one can put fields with null values at the bottom of the groups.

[blacksmithgu]

Task grouping is incoming (mainly an update to the DataArray and dv.taskList APIs to match so that groupBy and groupIn work properly otgether).

For customizing null behavior beyond what it does by default (I think null always is at the beginning currently?), I'll likely need to add a little more functionality to sorts to allow for SORT p ASC LOW NULLS or something equally verbose.

[wenlzhang]

Task grouping is incoming (mainly an update to the DataArray and dv.taskList APIs to match so that groupBy and groupIn work properly otgether).

This is great news!

I think null always is at the beginning currently?

Yes. For the cases I have encountered, null items are always on the top.

[ghost]

Can confirm. Whatever you set null as, it will always be on top which is quite annoying when trying to sort by dates.

[blacksmithgu]

As an aside to this, while the task improvements are coming in 0.4.23, nulls/undefined are also sorted at the end by default instead of the beginning now, which is probably slightly more useful default behavior.