Mongodb insert object into an array which is inside another attribute

Question

I need to update a document by inserting a bid into the Bid array which is part of Bid. An example document is below:

{
  "_id" : "1044300051",
  "Bids" : {
    "Bid" : [
        {
            "Bidder" : {
                "_id" : "pickford25",
                "_Rating" : 255,
                "Location" : "ANIME PARADISE",
                "Country" : "USA"
            },
            "Time" : "Dec-07-01 15:02:54",
            "Amount" : 1.12
        },
        {
            "Bidder" : {
                "_id" : "[email protected]",
                "_Rating" : 61,
                "Location" : "ARCADE, NEW YORK",
                "Country" : "USA"
            },
            "Time" : "Dec-09-01 15:02:54",
            "Amount" : 1.25
        }
    ]
  }
}

Here are some of the queries I have attempted:

db.items.update({_id: "1678348584"}, {$set: {Bids: "Bid[]"}},{$push: {"Bids.Bid": {"Amount":1000}}});
db.items.update({_id: "1678348584"}, {$push: {"Bids": [{"Amount":1000}]}});

The specific _id I am trying to update in the above examples has "Bids" set to null initially

Muhammad Usman · Accepted Answer · 2018-04-19 19:58:14Z

1

You are almost there. To access a nested array you'll have to use Bids.Bid. Your query should be something like

db.items.update({_id: "1678348584"}, {$push: {"Bids.Bid": {"Amount":1000}}});

edited Apr 19, 2018 at 19:58

answered Apr 19, 2018 at 19:49

Muhammad Usman

10.1k26 silver badges41 bronze badges

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

5 Comments

Roc47HS Over a year ago

That gives me this error: WriteResult({ "nMatched" : 0, "nUpserted" : 0, "nModified" : 0, "writeError" : { "code" : 16837, "errmsg" : "The positional operator did not find the match needed from the query. Unexpanded update: Bids.$.Bid" } })

Muhammad Usman Over a year ago

I just saw that. Updated the query.

Roc47HS Over a year ago

That gives this error: "code" : 16837, "errmsg" : "cannot use the part (Bids of Bids.Bid) to traverse the element ({Bids: null})" —The specific ID I am trying to update has Bids set to null initially

Muhammad Usman Over a year ago

well, you didn't mention that in your question

Roc47HS Over a year ago

Sorry, I didn't know that would affect the answer. I'll edit the question.

Collectives™ on Stack Overflow

Mongodb insert object into an array which is inside another attribute

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related