MongoDB aggregation sort by multiple fields

Question

This is my data:

{
   "name": "some name",
   "blockNumber": 10,
   "uniqueId: 2
},
{
   "name": "some name",
   "blockNumber": 9,
   "uniqueId: 3
},
{
   "name": "some name",
   "blockNumber": 10,
   "uniqueId: 1
},

This is my query:

myModel.aggregate([
        {
          $match: someFilter,
        },
        {
          $sort: { blockNumber: -1 },
        },
])

And there is the expected result:

{
   "name": "some name",
   "blockNumber": 10,
   "uniqueId: 1
},
{
   "name": "some name",
   "blockNumber": 10,
   "uniqueId: 2
},
{
   "name": "some name",
   "blockNumber": 9,
   "uniqueId: 3
}

I am looking for a way to additionally sort the data depending on a second value (in this case uniqueId) only if blockNum is the same for multiple documents, so that the final result is also sorted by descending uniqueId. Example:

{
   "name": "some name",
   "blockNumber": 10,
   "uniqueId: 2
},
{
   "name": "some name",
   "blockNumber": 10,
   "uniqueId: 1
},
{
   "name": "some name",
   "blockNumber": 9,
   "uniqueId: 3
}

The final result is incorrect. You mentioned sort by blockNumber descending and uniqueId ascending, the document with blockNumber: 10 and uniqueId: 1 will come first then followed by blockNumber: 10 and uniqueId: 2. — Yong Shun
– Yong Shun, Commented Aug 15, 2022 at 10:07
@1sina1 If I add another sort stage the final result will be sorted by uniqueId files, or I am wrong? — Naple
– Naple, Commented Aug 15, 2022 at 10:19
docs. if you use two sort stage it will get sort by the last one. if you use multiple fields on one $sort documents are first sorted by <field1>. Then documents with the same <field1> values are further sorted by <field2>. — 1sina1
– 1sina1, Commented Aug 15, 2022 at 10:27

General Grievance · Accepted Answer · 2023-12-21 17:00:33Z

2

I actually figured it out: just add a second field to the sort stage. The query is:

myModel.aggregate([
        {
          $match: someFilter,
        },
        {
          $sort: { blockNumber: -1, uniqueId: -1 },
        },
])

The result:

{
   "name": "some name",
   "blockNumber": 10,
   "uniqueId": 2
},
{
   "name": "some name",
   "blockNumber": 10,
   "uniqueId": 1
},
{
   "name": "some name",
   "blockNumber": 9,
   "uniqueId": 3
}

edited Dec 21, 2023 at 17:00

General Grievance

5,12039 gold badges39 silver badges60 bronze badges

answered Aug 15, 2022 at 10:27

Naple

6510 bronze badges

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

1 Comment

jigfox Over a year ago

would you mind, providing an example in your response? That way anyone googling this, has an example on how to do it

General Grievance · Accepted Answer · 2023-12-20 14:41:50Z

-3

Try this:

.sort({ $natural: 1 })

edited Dec 20, 2023 at 14:41

General Grievance

5,12039 gold badges39 silver badges60 bronze badges

answered Dec 20, 2023 at 6:31

Yogesh Negi

1

Collectives™ on Stack Overflow

MongoDB aggregation sort by multiple fields

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related