Update Embedded Documents in array without Repeating in MongoDb using Java

Question

I have the following structure in my document:

{
  "_id": 11111,
  "user": "[email protected]",
  "sites": [
    {
      "sitename": "site1",
      "url": "site2.com",
      "keywords": [],
    },
    {
      "sitename": "site2",
      "url": "site2.com",
      "keywords": [],
    },
    {
      "sitename": "site2",
      "url": "site2.com",
      "keywords": [],
    },
  ]
},{
  "_id": 2222,
  "user": "[email protected]",
  "sites": []
}

I'm going to find the document by ID(id:11111).there is multiple documents. Then I want to add new site to sites array in the document that contain 1111 _id. if sitename already have, the site should not add. How can I achieve this ?

Subhashree Pradhan · Accepted Answer · 2017-02-03 06:55:58Z

1

Updated Answer :

You can check that the _id is '11111', then check that the sitename doesn't exist and is not equal to the new sitename. And then you can $push the embedded document into the array.

db.collection.update(
 {
    _id:11111,
    'sites.sitename' : {$exists:false},
    'sites.sitename' : {$ne:'site4'}
 },
 {
    $push:
    {
        'sites': 
        {
            "sitename": "site4",
            "url": "site4.com",
            "keywords": []
        }
    }
 },
 {
    multi:true
 }
)

edited Feb 3, 2017 at 6:55

answered Feb 2, 2017 at 12:53

Subhashree Pradhan

8126 silver badges15 bronze badges

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

2 Comments

Amal Madawa Over a year ago

I want to add new site embedded document in to the array. not just newsite

Subhashree Pradhan Over a year ago

I have updated my answer as per your requirement. Kindly try that out.

Rahul Kumar · Accepted Answer · 2017-02-03 07:37:01Z

1

something like

db.collection.update({_id:11111, 'sites.sitename' : {$exists:false}},
 {$set : {'sites.$.sitename':'newsite.com'}},{multi:true})

Edit

if you want to add a sub-document for sitename

var sub = {'a':'a','b':'b'};

db.collection.update({_id:11111, 'sites.sitename' : {$exists:false}},
     {$set : {'sites.$.sitename':sub}},{multi:true})

edited Feb 3, 2017 at 7:37

answered Feb 2, 2017 at 7:31

Rahul Kumar

2,8411 gold badge24 silver badges31 bronze badges

1 Comment

Amal Madawa Over a year ago

I want to add embedded document in to the array. not just newsite

Collectives™ on Stack Overflow

Update Embedded Documents in array without Repeating in MongoDb using Java

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related