Apply ?? operator to ORDER BY clause and not only on SELECT
We are planning to add the ability for customers to add computed properties in Cosmos DB. These computed properties could be created with custom logic, indexed, and used in the ORDER BY clause.
Will update here when work has started or is complete.
Yaron Landau commented
My scenario is to apply order by on a field that might not exists.
In that case I want to treat the not exists value as null or empty string, and to be order by accordingly when I sort in alphabetic order.
I would expect to use something like:
order by c.AssignedTo ?? ""
in that way, if AssignedTo does not exists, it will be treat as ""