How to Update fields value in embedded documents of an Array in MongoDB using Java Driver

Question

I have the following structure in my document:

{
  "_id": ObjectId("5891a85bccaad513a844308f"),
  "sites": [
    {
      "site": "site1",
      "url": "site1.com",
      "status": 1,
    },
    {
      "site": "site2",
      "url": "site2.com",
      "status": 1,
    },
    {
      "site": "site3",
      "url": "site3.com",
      "status": 1,
    }
  ]
}

then I load all sites to UI. then I'll do some changes like following image and hit Update. I have deleted "site3". then My structure should update like as follow. site3 status should update to 0

{
  "_id": ObjectId("5891a85bccaad513a844308f"),
  "sites": [
    {
      "site": "site1",
      "url": "site1.com",
      "status": 1,
    },
    {
      "site": "site2",
      "url": "site2.com",
      "status": 1,
    },
    {
      "site": "site3",
      "url": "site3.com",
      "status": 0,
    }
  ]
}

How can I achieve this ?

s7vr · Accepted Answer · 2017-02-01 10:18:32Z

2

You can make use of positional $ update.

The query filter finds the matching site in the array and update part will set the status to 0 to matching element.

collection.updateOne(new Document("_id", new ObjectId("5891a85bccaad513a844308f")).append("sites.site", "site3"), Updates.set("sites.$.status", 0));

answered Feb 1, 2017 at 10:18

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

2 Comments

Amal Madawa Over a year ago

but the problem is How to find what site was deleted from the list. Imagine site2 and site3 will delete, how to get that sites to update ?

s7vr Over a year ago

I think you should keep track of it in the client code. It would be much simpler that way.

Collectives™ on Stack Overflow

How to Update fields value in embedded documents of an Array in MongoDB using Java Driver

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related