How to update an object inside an array inside an object with mongoose?

Question

Let's say I want to update "numberOfUpVotes" where the title is "Een centrale plek voor alle ideeen". I want the new value of "numberOfUpVotes" to be stored in the database. How do I do that?

Right now my code doesn't give an error, but it also doesn't work. This is what I've tried:

 Board.findOneAndUpdate(
        {"ideas.numberOfUpVotes": 23},
        {$set: {"numberOfUpVotes": 2}}, // $set
        {new: true},
        function (err, doc) {
            if (err) return res.send(500, {error: err});
            console.log("hallo");
        });

This is my data:

{
collectionName: "Board",
boardName: "IdeaBoard Schiphol",
ideas: [
    {
    _id: ida1,
    userId: id1,
    title: 'Een centrale plek voor alle ideeen',
    text: 'Een plek waar alle ideeen getoond worden op een scherm ofzo. Waar mensen dan op kunnnen stemmen via hun telefoon',
    date: new Date('2019-04-12'),
    numberOfUpVotes: 23,
    },
    {
    _id: ida2,
    userId: id1,
    title: 'Een uber voor kerstbomen',
    text: 'Bestaat zoiets al?',
    date: new Date('2019-04-11'),
    numberOfUpVotes: 1,
    }
],
QRcode: 'Dit is een QRcode'
}

KooiInc · Accepted Answer · 2019-05-06 08:46:56Z

1

You can do this without mongoose, something like.

const board = {
  collectionName: "Board",
  boardName: "IdeaBoard Schiphol",
  ideas: [
      {
      _id: 'ida1 (demo)',
      userId: 'id1 (demo)',
      title: 'Een centrale plek voor alle ideeen',
      text: 'Verkort voor demonstratie',
      date: new Date('2019-04-12'),
      numberOfUpVotes: 23,
      },
      {
      _id: 'ida2 (demo)',
      userId: 'id1 (demo)',
      title: 'Een uber voor kerstbomen',
      text: 'Bestaat zoiets al?',
      date: new Date('2019-04-11'),
      numberOfUpVotes: 1,
      }
  ],
  QRcode: 'Dit is een QRcode'
};

// find the filtered record and update its value
// the found record is a reference, so the value 
// is indeed changed within the object
board.ideas.filter(idea => idea.numberOfUpVotes === 23).shift().numberOfUpVotes = 2;

// QED
console.log(JSON.stringify(board, null, " "));

answered May 6, 2019 at 8:46

KooiInc

124k32 gold badges145 silver badges181 bronze badges

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

2 Comments

Tim MG Over a year ago

This works only for the object that is returned. I would like to edit the database object as well.

KooiInc Over a year ago

Ah, ok. I'm not well versed in mongoose, but isn't it possible to use a filter function (like in the answer) as first argument? Or maybe Board.findOneAndUpdate([{"ideas.numberOfUpVotes": 23}], ...)?

Tim MG · Accepted Answer · 2019-05-07 07:31:10Z

0

This is my final answer:

Board.update(
    {"ideas._id": mongoose.Types.ObjectId("abc123")},
    {$inc:{"ideas.$.numberOfUpVotes": 1}},
    function (err, doc) {
        if (err) return res.send(500, {error: err});
        console.log("succes! (:");
    })

answered May 7, 2019 at 7:31

Tim MG

5445 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to update an object inside an array inside an object with mongoose?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related