MongoDB Update a Nested Array [duplicate]

Question

I have the following JSON:

{
"_id" : ObjectId("57ce1a55899bf934e59edd0d"),
"project_name" : "Coupletones",
"list_users" : [
    "testmail"
],
"iterations" : [
    {
        "iteration_name" : "Iteration1",
        "tasks" : [ ]
    },
    {
        "iteration_name" : "Iteration2",
        "tasks" : [ ]
    },
]
}

I want to be able to push things into to the tasks array associated with Iteration 2. How do I properly query and insert to the correct location? This is what I have so far, but it always inserts into the tasks array associated with Iteration 1.

var ans = collection_projects.update({
      "project_name" : project_name,
      "list_users" : email,
      "iterations.iteration_name": iteration_name,
      },

      {$addToSet: {"iterations.$.tasks": {
        task_name: task_name,
        task_description : task_description,
        task_assignee: task_assignee,
        task_status : -1 } } }
    );

I've seen this: MongoDB nested array query but he is only trying to push to one nested array.

The positional update operator updates the first element it finds in the array, as answered by Shumi Gupta you need to include the element you want to update in de find/condition. One important notice, the positional update updates the first and ONLY the first element. If you need to update multiple elements in an array you (at this moment) need to do it client side. There is a JIRA ticket for this wish — HoefMeistert
– HoefMeistert, Commented Sep 6, 2016 at 5:14

Shumi Gupta · Accepted Answer · 2016-09-06 02:11:46Z

2

try by this method

conditions = {
    "_id": ObjectId"57ce1a55899bf934e59edd0d",
    "iterations.iterations_name": "Iteration2"
  };
updates = {
   $push: {
     "iterations.$.tasks": "success"
   }
};
options = {
  upsert: true
};
Model.update(conditions, updates, options, callback);

answered Sep 6, 2016 at 2:11

Shumi Gupta

1,5252 gold badges19 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

MongoDB Update a Nested Array [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related