Search code examples
mongodbsubdocument

MongoDB update a subdocument attribute

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?

Solution

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

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