How can we improve Azure Cosmos DB?

Support OrderBy and OrderByDescending in Nested Arrays

For example in a document structure such as:

{
"id": "some id",
"things": [
{ "value": "5" },
{ "value": "2" },
{ "value: "7" }
]
}

It would be great to be able to do something like:

queryable.Select(x => x.Things.OrderByDescending(y => y.Value)).AsEnumerable.FirstOrDefault();

54 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Tom Glenn shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

This is something we have on our backlog and eventually plan to implement this but it is not on our short-term plan. Will mark this as under review for now as we will continue to review the comments and votes on this issue as we revisit feedback.

Thanks for your request.

3 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base