Mongodb C# driver sort by nested attribute

Question

How do i use the C# driver to sort by a nested object (from a mapreduce query)

{"_id": { "date" : "02/01/2001"} }"

SortBy.Descending("_id")  'Sorts by "_id" descending
SortBy.Descending("???")  'Sorts by "date" descending

But Im not sure what to put in value to make this happen

Andre de Frere · Accepted Answer · 2012-09-24 01:05:30Z

2

In the case you have given, it will not be necessary to specify the nested object since sorting by the _id field will functionally sort on the date contained in that field.

You can however reach into nested objects using the dot notation when needed. This would look like:

SortBy.Descending("_id.date")

answered Sep 24, 2012 at 1:05

Andre de Frere

2,74318 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tarang Over a year ago

Although this doesn't work in a mapreduce situation it is still the correct way to sort by nested attributes

Collectives™ on Stack Overflow

Mongodb C# driver sort by nested attribute

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related