MongoDB push data to specific array element

Question

Hi guys so I'm doing meteor mongo db, I use findAndModify package

Ips.findAndModify({

      //Find the desired document based on specified criteria
      query: {
        "ipAdr": clientIp,
        connections: {
          $elemMatch: {
            connID: clientConnId
          }
        }
      },

      //Update only the elements of the array where the specified criteria matches
      update: {
        $push: {
          'connections': {
            vid: result.data.vid,
            firstName: result.data.properties.firstname.value,
            lastName: result.data.properties.lastname.value
        }
      }
    }); //Ips.findAndModify

So I find the element that I need however my info is being pushed to the whole connections array, but I want to push my info into that specific element. What should I do here? I tried

$push: {
              'connections.$': {
                vid: result.data.vid,

but it gives error. Please help.

what error are you getting??

vighanesh mandavkar
– vighanesh mandavkar

2016-11-03 08:35:37 +00:00
Commented Nov 3, 2016 at 8:35 — vighanesh mandavkar
– vighanesh mandavkar, Commented Nov 3, 2016 at 8:35

Andriy Simonov · Accepted Answer · 2016-11-03 09:33:42Z

1

You don't need to use the $push operator here as it adds a new element to array, instead you need to modify an element that is already in the array, try the $set operator to update as follows:

update: {
        $set: {
          'connections.$.vid': result.data.vid,
          'connections.$.firstName': result.data.properties.firstname.value,
          'connections.$.lastName': result.data.properties.lastname.value
        }
      }

Take into account that this way you will change only one element of the array that satisfies the condition from the $elemMatch statement.

answered Nov 3, 2016 at 9:33

Andriy Simonov

1,3081 gold badge12 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

MongoDB push data to specific array element

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