How to update array List of object at particular index in the collection in java

Question

public Class Customer{
    private long id;
    private String name;
    private String companyName;
    private List<Environment> environment = new ArrayList<>();
}

public Class Environment{
    private int clusterid;
    private string clusterName
}

My Collection in Mongo DB


{  
  "id":1,
  "name":"xyz",
  "companyName":"abc",
  "environment":[
    {
      "clusterid":2,
      "clusterName":"qwe"
    },
    {
      "clusterid":6,
      "clusterName":nme"
    }
  ]
}

 want to update environment List of index 1 with returning whole environment List. How do I do this with spring boot? I want to update particular index of list fetching other too in the collection .

public int updateEnv(Customer customer) {
    Query query = new Query();
    query.addCriteria(Criteria.where("id").is(customer.getid()));
    Update update = new Update();
    update.set("environment", customer.getEnvironment());
    return mongoUtil.update(query, update, Customer.class);
}

This query updating the whole environment List with the value in the list instead of at particular index. Please guide about positional operator .How to do this with positional operator in java

eol · Accepted Answer · 2020-10-24 14:44:51Z

0

You should be able to just pass the index to the update query. So if you want to update/replace the element at index 1, you can do:

update.set("environment.1", customer.getEnvironment())

answered Oct 24, 2020 at 14:44

eol

24.7k6 gold badges53 silver badges72 bronze badges

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

3 Comments

Asha SIngh Over a year ago

this will set when u know the index. I want to update dynamically

eol Over a year ago

That's not quite what your question states "...want to update .. of index 1" :). So, how would you determine the index? By the clusterId?

Asha SIngh Over a year ago

suppose in my collection I have environment which is basically an arraylist. now i want to run query for update so instead of { "id":1, "name":"xyz", "companyName":"abc", "environment":[ { "clusterid":2, "clusterName":"qwe" }, { "clusterid":6, "clusterName":nme" } ] } ` I want to have` { "id":1, "name":"xyz", "companyName":"abc", "environment":[ { "clusterid":3, "clusterName":"fgh" }, { "clusterid":6, "clusterName":nme" } ] }

wak786 · Accepted Answer · 2020-10-24 18:15:23Z

0

Try this updated query.

Updated Mongo Playground

db.collection.update({
  id: 1/**customer id*/
  
},
{
  "$set": {
    "environment.$[element]": {
      "clusterId": 4,
      /**environment object with updated clusterId*/
      "clusterName": "asd"/**environment object with updated clusterName*/
      
    }
  }
},
{
  arrayFilters: [
    {
      "element.clusterid": 6/**clusterId of environment you have to update*/
      
    }
  ]
})

edited Oct 24, 2020 at 18:15

answered Oct 24, 2020 at 15:53

wak786

1,6351 gold badge10 silver badges12 bronze badges

7 Comments

Asha SIngh Over a year ago

I have given a example of collection above in which environment List is given i want to update whole like for example instead of { "clusterid":6, "clusterName":nme" } , I want to update {"clusterid":4,"clusterName":"asd"}.

wak786 Over a year ago

Okay cool. Here is what i understood. Tell me if am wrong. SO we have the information of which object to update right? Like in your comment we know that we want to update ` { "clusterid":6, "clusterName":nme" }` with {"clusterid":4,"clusterName":"asd"}

Asha SIngh Over a year ago

yes , I have gone through positional set and all but could not get the idea of writing query in java

wak786 Over a year ago

Updated the query. Can run and check if that is what you expect.

wak786 Over a year ago

Once we get the expected result. We can work on converting it to java

|

Collectives™ on Stack Overflow

How to update array List of object at particular index in the collection in java

2 Answers 2

3 Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related