How to delete particular no of elements from array in mongodb

Question

I have collection as below

"_id" : "PS8720_18",
    "AlertID" : "18",
    "Status" : "ACTIVE",
    "triggerHistory" : [ 
        {"triggerId" : "1535081507421"}, 
        {"triggerId" : "1535105196735"}, 
        {"triggerId" : "1535341330335"}, 
        {"triggerId" : "1535364578821"}
 ]

I want to delete all element and just want keep last two entries in the array. Each document has different no of elements in array. How do I achieve this?

Nitin Bhanderi · Accepted Answer · 2018-10-23 10:04:30Z

1

Please Check with the following Query

db.getCollection('youtablename').update({}, {
 $push: {
  triggerHistory: {
     $each: [ ],
     $slice: -2
  }
}},{multi:true})

Hope it Helps !!

answered Oct 23, 2018 at 10:04

Nitin Bhanderi

3322 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

How to delete particular no of elements from array in mongodb

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