Updating second level embedded array in mongdb without using index?

Question

I am having following document in mongodb

 {
   "CompanyCode" : "xyz",
   "TktDetail" : [
        {
        "Type" : "ab yyy (123+4)",
         "Qty" : [{
            "1-Aug" : 48
             }, {
              "1-Sep" : 42
            }]
         }, 
         {
        "Type" : "bc xyz (123+4)",
         "Qty" : [{
        "10-Aug" : 2
              }, {
             "10-Sep" : 2
              }, {
               "11-Sep" : 2
            }]
     }]
  }

I want to update the 1-Aug value in the Qty array which is embedded inside the TktDetail array.

I had tried with the following query.Its not updating

 db.test.update({"CompanyCode":"xyz","TktDetail.type":"ab yyy (123+4)"},{$set:{"TktDetail.$.Qty.$.1-Aug":55}});

Any help will be great.

not possible to do in one call until: jira.mongodb.org/browse/SERVER-831 — Sammaye
– Sammaye, Commented Sep 20, 2013 at 11:45

Sammaye · Accepted Answer · 2013-09-20 11:46:20Z

1

This is currently not possible in a single call but here is a JIRA you can watch: https://jira.mongodb.org/browse/SERVER-831 hopefully it might be in for 2.5 (2.6 stable).

answered Sep 20, 2013 at 11:46

Sammaye

44k7 gold badges110 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

Updating second level embedded array in mongdb without using index?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related