How to modify array same values based on $

Question

I tried to modify array values with following :

        final UpdateResult ur = operations.updateMulti(
                new Query().addCriteria(
                        Criteria.where("tags.applications").in(Collections.singletonList(4))),
                new Update().set(String.format("%s.$","tags.applications"), 8),
                "testMetaModel");

the problem is, if the array is like tag: application: [1,2,3,4,4,5,6] If I use above "$" update, it could only update the first matched "4", but I want to update all "4" to "8", what should I do ? I use spring MongoTemplate.

Here are posts with answers related to your issue of updating an array element based on condition: stackoverflow.com/questions/60701824/… and stackoverflow.com/questions/61002409/… — prasad_
– prasad_, Commented Apr 13, 2020 at 11:50

Vijay Rajpurohit · Accepted Answer · 2020-04-14 08:13:56Z

1

I have used the positional filters, refer here.

shell query:

db.demo.update(
  {},
  {
    $set:{
      "a.$[element]":8
    }
  },
  {
    arrayFilters:[
      {
        "element":4
      }
    ]
  }
)

This will update all the matched elements in the provided array.

The above shell query is working fine. you can integrate it with your spring data. I tried to add that in springdata but fix it according to the shell query I provided if any issue is faced. :)

Update update=new Update().set("tags.applications.$[element]", 8).filterArray(Criteria.where("element").is(4)); 
final UpdateResult ur = operations.updateMulti(
        new Query(),
        update,
        "testMetaModel");

Update

Java driver query:

db.getCollection("demo").updateMany(
        new Document(),
        new Documen("$set", new Document("a.$[element]", 8)),
        new UpdateOptions().arrayFilters(
            Arrays.asList( 
            Document.parse("{'element': 4}")
            )
        )
);

edited Apr 14, 2020 at 8:13

answered Apr 13, 2020 at 12:18

Vijay Rajpurohit

1,3622 gold badges13 silver badges25 bronze badges

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

3 Comments

PigeonIsBigBird Over a year ago

It seems that I don't have the method: "update.filterArray(Criteria.where("element")." ? what could be done

Vijay Rajpurohit Over a year ago

seems like spring data does not have UpdateOptions. you can use java driver to update the document. please refer this stackoverflow.com/a/55503265/8383549

Vijay Rajpurohit Over a year ago

I have updated my answer with the java driver query. hope this will help you :)

Collectives™ on Stack Overflow

How to modify array same values based on $

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related