Special string sort logic

[dim882]

Is it possible to sort by strings but not alphabetically but where the strings map to some value? For example, I have a burner metadata field, as in, something is either on a "front burner" or a "back burner". I'd want these files sorted with front first, but alphabetically, it's after back. I was looking at expressions and trying to see if I could somehow map front to 1 and back to 2 with lambdas but I can't see a way to do it. Is that possible? Thanks!

[dim882]

I almost have something working, but I can't get it to work well with null fields.

sort object("front", 0, "back", 1, "icebox", 2)[burner] asc

This works but null fields are sorted first. I tried using default (and ldefault) and for some reason that filters null fields out of the results, which isn't what I was hoping for.

sort object("front", 0, "back", 1, "icebox", 2)[default(burner, 3)] asc

[AB1908]

object("front", 0, "back", 1, "icebox", 2, "nonexistent", 3)[default(burner, "nonexistent")]

[dim882]

Of course! 🤦‍♂️ Thanks!