MongoDB CRUD Operations >
MongoDB CRUD Tutorials >
Limit Number of Elements in an Array after an Update

Limit Number of Elements in an Array after an Update¶

On this page

Synopsis
Pattern

New in version 2.4.

Synopsis¶

Consider an application where users may submit many scores (e.g. for a test), but the application only needs to track the top three test scores.

This pattern uses the $push operator with the $each, $sort, and $slice modifiers to sort and maintain an array of fixed size.

Important

The array elements must be documents in order to use the $sort modifier.

Pattern¶

Consider the following document in the collection students:

copy

{
  _id: 1,
  scores: [
            { attempt: 1, score: 10 },
            { attempt: 2 , score:8 }
          ]
}

The following update uses the $push operator with:

the $each modifier to append to the array 2 new elements,
the $sort modifier to order the elements by ascending (1) score, and
the $slice modifier to keep the last 3 elements of the ordered array.

copy

db.students.update(
                    { _id: 1 },
                    { $push: { scores: { $each : [
                                                   { attempt: 3, score: 7 },
                                                   { attempt: 4, score: 4 }
                                                 ],
                                         $sort: { score: 1 },
                                         $slice: -3
                                       }
                              }
                    }
                  )

Note

When using the $sort modifier on the array element, access the field in the subdocument element directly instead of using the dot notation on the array field.

After the operation, the document contains only the top 3 scores in the scores array:

copy

{
   "_id" : 1,
   "scores" : [
                { "attempt" : 3, "score" : 7 },
                { "attempt" : 2, "score" : 8 },
                { "attempt" : 1, "score" : 10 }
              ]
}