Can't insert object into object array in Mongodb

Question

I've been trying to get certain elements into this code. (Please ignore the silly dummy data)

{
"Order_Number": "1",
"Status": "Pending",
"Customer":{
    "First_Name": "Juan",
    "Second_Name": "De La Cruz",
    "Email": "[email protected]",
    "contact": "0923275937"
           },
"Shipping_Address": "291,Ominous Building, Quezon City, Philippines",
"Billing_Address": "IOU, Iowa, USA",
"Weight": "200 lbs.",
"Description": "Joots",
"Tracking Information": {
    "Tracking Number": "000000001",
    "Shipping History": {
        "Shipping Transactions": [
            {
                "Date Received": "10/1/2013",
                "Date Released": "10/10/2013",
                "Source": "Center of the earth",
                "Control Number": "100010001"
            },
            {
                "Date Received": "10/2/2013",
                "Date Released": "10/12/2013",
                "Source": "Center of Venus",
                "Control Number": "100010002"
            },
            {
                "Date Received": "10/3/2013",
                "Date Released": "10/13/2013",
                "Source": "San Francisco",
                "Control Number": "100010003"
            }
        ]
    }
}
}

Now , I've been trying to get these elements into "Shipping Transactions".

{

        "Date Received": "10/2/2013",
        "Date Released": "10/11/2013",
        "Source": "Center of Mars",
        "Control Number": "100010005"
}

I've tried doing push , but it doesn't even seem to add itself to the array.

{$push:{"Tracking Information":{"Shipping History":{"Shipping Transactions":
   [{"Date Received": "10/4/2013",
    "Date Released": "10/11/2013",
    "Source": "Center of Mars",
    "Control Number": "100010005"}]
 }

Might this code have a flaw or am I doing something wrong ? I'm only using MongoDb's web shell btw.

Sergio Tulentsev · Accepted Answer · 2013-10-03 13:17:10Z

2

This should do it:

{
  $push:{"Tracking Information.Shipping History.Shipping Transactions": {"Date Received": "10/4/2013",
    "Date Released": "10/11/2013",
    "Source": "Center of Mars",
    "Control Number": "100010005"}}
}

It's called dot notation. Really useful.

answered Oct 3, 2013 at 13:17

Sergio Tulentsev

231k43 gold badges381 silver badges373 bronze badges

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

Collectives™ on Stack Overflow

Can't insert object into object array in Mongodb

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