MongoDB sort by Array order

Question

let say I have documents

[
  {
    score : 3,
  },
  {
    score : 1,
  },
  {
    score : 2,
  }
]

and an array contain order of score

const array = [2,1,3]

How can I sort documents by order of array

expected result :

[
  {
    score : 2,
  },
  {
    score : 1,
  },
  {
    score : 3,
  }
]

Noel · Accepted Answer · 2022-12-13 07:14:34Z

1

Using indexOfArray

db.collection.aggregate([
{
    $addFields: {
        "order": {
            $indexOfArray: [[2,1,3], "$score"]
        }
    }
},
{
    $sort: {
        "order": 1
    }
}
]);

Playground

answered Dec 13, 2022 at 7:14

Noel

10.6k30 gold badges53 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

MongoDB sort by Array order

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related