How to get the last N elements of an array in mongoDB?

Question

I have this collection example:

{
  "field1" : "A",
  "field2" : [
    {
      "val" : 1,
      "time" : ISODate("2010-07-13T00:18:35.178Z")
    },
    {
      "val" : 4,
      "time" : ISODate("2011-07-14T23:29:40.012Z")
    },
    {
      "val" : 8,
      "time" : ISODate("2012-07-14T23:29:45.012Z")
    },
    {
      "val" : 1,
      "time" : ISODate("2013-07-13T00:18:35.178Z")
    },
    {
      "val" : 2,
      "time" : ISODate("2014-07-14T23:29:40.012Z")
    },
    {
      "val" : 3,
      "time" : ISODate("2015-07-14T23:29:45.012Z")
    }
  ]
}

field2 is an array of documents and I can't get the last N documents.

For example, in this example I want to get the last 2 values:

{
  "field1" : "A",
  "field2" : [
    {
      "val" : 2,
      "time" : ISODate("2014-07-14T23:29:40.012Z")
    },
    {
      "val" : 3,
      "time" : ISODate("2015-07-14T23:29:45.012Z")
    }
  ]
}

Xavier Guihot · Accepted Answer · 2022-03-13 12:44:04Z

2

Starting in Mongo 5.2, we can use the $lastN aggregation operator:

// { values: [1, 5, 4, 12, 3] }
// { values: [3] }
// { values: [7, 8, 2] }
db.collection.aggregate(
  { $set: { values: { $lastN: { n: 2, input: "$values" } } } }
)
// { values: [12, 3] }
// { values: [3] }
// { values: [8, 2] }

answered Mar 13, 2022 at 12:44

Xavier Guihot

62.8k26 gold badges320 silver badges202 bronze badges

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

Comments

JohnnyHK · Accepted Answer · 2019-08-05 17:27:16Z

2

You can use the $slice projection operator with a negative value to get the last n elements of an array field:

db.collection.find({}, {field2: {$slice: -2}})

answered Aug 5, 2019 at 17:27

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

Collectives™ on Stack Overflow

How to get the last N elements of an array in mongoDB?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related