$in operator ordering

Working with Data
2

Hello @Subham_Kumar_Sahu, Welcome to the MongoDB Community Forum,

The $in operator won’t preserve the order or documents in response as passed in the match.

You have to try an aggregation query with some additional stage for that operation, something like this, Consider _id is your matching property,

  • $match stage to match your condition
  • $addFields to introduce a new field index
  • $indexOfArray to find the index of the current document’s _id property in your match array
  • $sort to sort the result by index field in ascending order
var matchArray = [uuid5,uuid1,uuid2];
db.collection.aggregate([
  { $match: { _id: { $in: matchArray } } },
  {
    $addFields: {
      index: {
        $indexOfArray: [matchArray, "$_id"]
      }
    }
  },
  { $sort: { index: 1 } }
])

Look at a similar question for more information,

3 Likes