How to update an integer array element in Mongo DB using Spring Data?

Question

We need to update the latitude coordinate (address.coord[0]) whose value is less than 50. How to build the query to do this using Spring Data. The following few snippets show the methods we tried.

The below one do the update but it removes coord-0(latitude) and coord-1(longitude)

Criteria c = where("address.coord").lt(value);
Update update = new Update().set("address.coord", value);
WriteResult result = mongodb.updateMulti(query(c), update, "restaurants");

The below one could't even able to find the documents matching the criteria

Criteria c = where("address.$.coord").lt(value);
Update update = new Update().set("address.$.coord", value);
WriteResult result = mongodb.updateMulti(query(c), update, "restaurants");

Thanks in advance for your valuable answers

Criteria c = where("address.coord.0").lt(value); Update update = new Update().set("address.coord.0", value); WriteResult result = mongodb.updateMulti(query(c), update, "restaurants"); — chridam
– chridam, Commented Sep 21, 2017 at 14:48
"address.$.coord" implies address is an array which is not the case hence the query which uses this fails. — chridam
– chridam, Commented Sep 21, 2017 at 14:53
@Veeram I tried that too, I got the same result as that of in my second code snippet. It updated the address.coord[0] but I lost address.cord[1] — Vishnu S Kumar
– Vishnu S Kumar, Commented Sep 21, 2017 at 15:03
Sorry didn't realize address was not a embedded array and coord is. Something like Criteria c = where("address.coord").lt(value); Update update = new Update().set("address.coord.$", value); WriteResult result = mongodb.updateMulti(query(c), update, "restaurants"); — s7vr
– s7vr, Commented Sep 21, 2017 at 15:05

Vishnu S Kumar · Accepted Answer · 2017-09-21 15:19:21Z

1

 Criteria c = where("address.coord.0").lt(value); 
 Update update = new Update().set("address.coord.0", value);
 WriteResult result = mongodb.updateMulti(query(c), update, "restaurants");

address.coord.0

answered Sep 21, 2017 at 15:19

Vishnu S Kumar

68610 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to update an integer array element in Mongo DB using Spring Data?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related