Order By Null Handling
Currently if you do an order by on a nullable value, the documents are not returned at all. Please add functionality similiar to Application Insights where you can specify if the documents with the null value appear at the beginning or end of the sort.
This feature was mistakenly marked as having been started. This feature is still in plan and will be started in our next cycle. Will update when work starts and when it becomes generally available.
Majid Shams commented
Hi - I was wondering if the "next cycle" has started yet. - Thank you.
Is this issue closed
Matthew Kowalski commented
When using the ORDER BY clause, if a document does not contain the property which is being sorted on, that document will not be included in the result set.
Would it be possible to treat 'undefined' the same as 'null' when returning results sets that use an ORDER BY clause?