Spring-data-mongodb : mongoTemplate - remove element from array in collection of documents [duplicate]

Question

Suppose I have a collection containing documents like :

{name: "a", preferences: ["apples","oranges","bananas"]}    
{name: "b", preferences: ["apricots","oranges","strawberries"]}
{name: "c", preferences: ["oranges","plums"]}
{name: "d", preferences: ["apples","plums","oranges"]}
{name: "e", preferences: ["strawberries","bananas"]}

Now there are no more oranges so I want to remove them from all documents and end up with :

{name: "a", preferences: ["apples","bananas"]}    
{name: "b", preferences: ["apricots","strawberries"]}
{name: "c", preferences: ["plums"]}
{name: "d", preferences: ["apples","plums"]}
{name: "e", preferences: ["strawberries","bananas"]}

I've been banging my head to know whether, using Spring's mongoTemplate, there is any straightforward way to do this, apart from the obvious (and, I guess, inefficient as the collection is potentially huge) iterative way ? Thanks for your help.

You can try Update update = new Update(); update.pull("preferences", "oranges"); mongoTemplate.updateMulti(new Query(), update, collection_name) — s7vr
– s7vr, Commented Jan 15, 2018 at 17:28

pvpkiran · Accepted Answer · 2018-01-15 22:02:17Z

1

Something like this will do

Update update = new Update();
new Update().pull("preferences", "oranges");
Criteria criteria = Criteria.where("preferences").elemMatch(Criteria.where("oranges").exists(true));// Use this if you don't want to do the above update for all documents.

mongoTemplate.updateMulti(new Query(criteria), update, "collection_name");

edited Jan 15, 2018 at 22:02

answered Jan 15, 2018 at 18:00

pvpkiran

27.2k13 gold badges106 silver badges149 bronze badges

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

1 Comment

maslan Over a year ago

This actually does not work. The elemMatch function can be used only when the array contain objects. When the array contains plain strings it should be Criteria criteria = Criteria.where("preferences").all("oranges");

Collectives™ on Stack Overflow

Spring-data-mongodb : mongoTemplate - remove element from array in collection of documents [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related