(MongoDB / Mongoose) Increment a value in an array of objects

Question

I have a document that looks like this:

{
  "id": "12345",
  "channels": [
    {
      "id": "67890",
      "count": 1
    }
  ]
}

What I want to do is increment a given channel count by one. So a user sends a message and I look up the user, find the proper channel by "id" in the "channels" array, and increment "count" by one.

I tried the following query:

UserModel.findOneAndUpdate({id: this.id}, 
  {'channels.id': channel.id}, 
  {$set: {$inc: {'channels.$.count': 1}}}

It didn't fail, surprisingly. But it also didn't increment the count.

mickl · Accepted Answer · 2020-04-06 22:42:29Z

2

Two fixes needed: query has to be a single object and $inc is a separate operator so you don't need $set:

UserModel.findOneAndUpdate({id: this.id, 'channels.id': channel.id},
    { $inc: {'channels.$.count': 1}})

answered Apr 6, 2020 at 22:42

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

1 Comment

RSH Over a year ago

Perfect, that was it. Thank you sir.

Collectives™ on Stack Overflow

(MongoDB / Mongoose) Increment a value in an array of objects

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related