Is it possible to order groupings so that null is last

[dim882]

Say I have a simple query like

task where !completed
group by p

I want the groups to be ordered 1, 2, 3... null, but null is first, so they're displayed null, 1, 2, 3.... Is this ordering possible? Thanks!

[AB1908]

sort p?

Edit:

task where !completed
group by p
sort ldefault(p, "9999")

[dim882]

Thanks for the quick response. For me, that still sorts null as first, though.

In SQL you can usually do something like order by p NULLS LAST. I suppose what I want is even more complicated though, since I want to order the groups, and sort will only sort the items in the group, I think?

[AB1908]

Current workaround would be to sort map(field, (t) => t ?? -1), essentially redefining the null at sort time. Not 100% sure it works though.

[dim882]

Ah, I see. When I try that, it chokes on ?? though. I assume that's meant as the nullish coalescing operator? Do you know what syntax is allowed for map? The docs say it takes a func, but it seems to choke on plain JavaScript. So I guess it's a Dataview lambda, which means it would only accept Dataview expressions for the return value? If so, then maybe the only thing is to use the full JS API?

[AB1908]

Yea nullish operator probably wasn't what we wanted to use. Let me try a few things out.

[AB1908]

task where !completed
group by p
sort ldefault(p, "9999")

I think this does a better job of the initial idea.

[dim882]

Ah! That worked! Didn't know about that function. Thanks so much!

…

On Thu, Apr 07, 2022 at 1:18 PM, AB1908 < ***@***.*** > wrote: task where !completed group by p sort ldefault(p, "9999") I think this does a better job of the initial idea. — Reply to this email directly, view it on GitHub ( #985 (reply in thread) ) , or unsubscribe ( https://github.com/notifications/unsubscribe-auth/AAA7YYRLG2OQK5VOSBJHOX3VD47H7ANCNFSM5STNCTFA ). You are receiving this because you authored the thread. Message ID: <blacksmithgu/obsidian-dataview/repo-discussions/985/comments/2526451 @ github. com>