MongoDB update a subdocument attribute

Question

Let me start by saying I'm sorry if this has been answered, but I can't get other questions on this site to fit my needs and, more importantly, work.

I have the below example document, with a subdocument of 'address':

{ 
    "_id" : ObjectId("....")
    ,"addresses" : 
        [{
            "start" : ISODate("1973-07-10T00:11:51.111Z")
            ,"value" : "123 long road"
        }] 
}

What I need to do is to close the existing address record with an end attribute, and add a new line for the new address with a new start and value attribute. Eventually, I'll need to do this again so the code needs to update the subdocument record where end does not exist.

The below code does not work, but it's about as far as I can get:

db.sites.update(
      {"_id" : ObjectId("....")
        , "addresses.end" : {"$exists" : false}}
     ,{"$set": {"addresses.$.end" : "fdsa"}});

This gives the error:

Cannot apply the positional operator without a corresponding query field containing an array.

Can anyone point me in the right direction?

dgiugg · Accepted Answer · 2014-08-04 14:19:48Z

2

Juste replace in your query "addresses.end" : {"$exists" : false} with:

addresses: {$elemMatch: {end: {$exists: false}}}

answered Aug 4, 2014 at 14:19

dgiugg

1,33414 silver badges24 bronze badges

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

4 Comments

JAC2703 Over a year ago

Brilliant, the lot of you. Thanks very much :)

JAC2703 Over a year ago

Guys, it seems that using addresses.$.end in conjunction with $elemMatch only ever updates the first subdocument, and not the one which was a missing end attribute. any ideas how to always update the subdocument that doesn't have an end attribute?

dgiugg Over a year ago

It works for me. It updates the first subdocument with a missing end attribute... Are you sure you do not have several subdocuments with a missing end attribute?

JAC2703 Over a year ago

Got it working too, I had another condition that was never true. Thanks again.

Apmis · Accepted Answer · 2014-08-04 14:20:45Z

0

Your address field is poorly defined. you need make it a subdocument or an array of subdocuments. ie { "_id" : ObjectId("....") ,"addresses" : [ { "start" : ISODate("1973-07-10T00:11:51.111Z") ,"value" : "123 long road" } ] }

your query should then work!

answered Aug 4, 2014 at 14:20

Apmis

171 silver badge1 bronze badge

2 Comments

JAC2703 Over a year ago

Sorry, I missed out the curlies {} - they are there really, just hiding in my above post. I'll make an edit.

Apmis Over a year ago

@Barno is there a workaround doing multiple updates?

Barno · Accepted Answer · 2014-08-04 14:23:56Z

0

I think that the Query should be more specific

**Updated **

db.sites.update ( {"_id" : ObjectId("...."), addresses: { "$elemMatch" : { end:{$exists : false}} } }, {"$set": {"addresses.$.end" : "fdsa"}});

db.sites.find()

results:

{
    "_id" : ObjectId("53df93da560b7815e1237934"),
    "addresses" : [ 
        {
            "start" : ISODate("1973-07-10T00:11:51.111Z"),
            "value" : "123 long road",
            "end" : "fdsa"
        }
    ]
}

but you can update only one

Take a look http://docs.mongodb.org/manual/reference/operator/projection/positional/#proj.S

You can t update more element in Array https://jira.mongodb.org/browse/SERVER-1243

edited Aug 4, 2014 at 14:23

answered Aug 4, 2014 at 14:16

Barno

3,3415 gold badges31 silver badges60 bronze badges

1 Comment

dgiugg Over a year ago

This is not what the OP is asking: he wants to update the element that does not have and "end" attribute.

Collectives™ on Stack Overflow

MongoDB update a subdocument attribute

3 Answers 3

4 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related