Insert object into MongoDB array element

Question

I have to insert an object in every array in the MongoDB document. The items array displayed below has itemList; in every itemList I have to insert a itemSpec. The desired document shape before and after the process is shown below:

Before process

{
  "items": [
    {
      "itemList":{
        "rejected": true
      },
      "fProcBy": "automatic"
    },
    {
      "itemList":{
        "rejected": true
      },
      "fProcBy": "automatic"
    }
  ]
}

After process:

{
  "items": [
    {
      "itemList":{
        "rejected": true
      },
      "itemSpec":{
        "approved": true
      },
      "fProcBy": "automatic"
    },
    {
      "itemList":{
        "rejected": true
      },
      "itemSpec":{
        "approved": true
      },
      "fProcBy": "automatic"
    }
  ]
}

So in each element of the items array there has to be inserted a new object property itemSpec.

DAXaholic · Accepted Answer · 2016-07-04 07:37:44Z

2

I am not aware of a solution which does it in a single run, but with the following simple script the maximal number of iterations is equal to the maximal number of array elements you have in a single documents, which is probably not so high (but it's just a guess as I have no further information about your data):

var q = { "items.itemSpec": null };
var u = { 
    $set: {
        "items.$.itemSpec" : {
            "approved": true
        }
    }
};
var yourColl = db.getCollection('fooBar');
while (yourColl.find(q).count() > 0) {
    yourColl.update(q, u, { multi: true });
}

answered Jul 4, 2016 at 7:37

DAXaholic

35.9k6 gold badges84 silver badges77 bronze badges

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

Comments

KARTHIKEYAN.A · Accepted Answer · 2018-02-14 07:09:00Z

1

Use $push operator to update array in a document.

Try This:

db.test.update({"_id":"yourUniqueId"}, 
              {$push: {  "items":{ "itemSpec":{"approved": true}}}});

edited Feb 14, 2018 at 7:09

KARTHIKEYAN.A

20.5k11 gold badges139 silver badges151 bronze badges

answered Jul 4, 2016 at 6:32

Shantanu Madane

6155 silver badges15 bronze badges

7 Comments

Newton Over a year ago

this will add the itemSpec as "an element" of the items array. OP wants to add it inside the actual elements instead

Sabareesh Gunasekaran Over a year ago

It creating new array element as below, I have to update as I mentioned above { "items": [ { "itemList": { "rejected": true }, "fProcBy": "automatic" }, { "itemList": { "rejected": true }, "fProcBy": "automatic" }, { "itemSpec": { "approved": true } } ] }

Shantanu Madane Over a year ago

I did not get what you wanted to say!!! can you tell me what is the issue

Shantanu Madane Over a year ago

did you try "items.0"?

Sabareesh Gunasekaran Over a year ago

code u provided is adding new array item[2], in the given example, the code has to insert the itemSpec, in available array elements as mentioned in the after process

|

Collectives™ on Stack Overflow

Insert object into MongoDB array element

2 Answers 2

Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related