How to remove elements from nested object array?

Question

I'm trying to remove elements from nested object array. My document looks like this:

{ "_id" : ObjectId("5a79b8a6b2ba9a49359fa3c3"), "_class" : "com.PersonEntity", "records" : [ { "number" : "4905537", "label" : "ASH" }, { "number" : "KM537", "label" : "JAP" }, { "number" : "49537", "label" : "JAP" } ] }

I want to delete all the records of all the documents where the record has the label "JAP".

This is the way I'm trying to do it:

Update update = new Update().pull("records", new BasicDBObject("label", "JAP")); mongoOperations.updateMulti(new Query(), update, PersonEntity.class);

It seems that there is something wrong with this Update because removing is not working.

Can any body help me with this?

What is your mongo server and spring mongo jar version ?

s7vr
– s7vr

2018-02-20 12:53:16 +00:00
Commented Feb 20, 2018 at 12:53 — s7vr
– s7vr, Commented Feb 20, 2018 at 12:53

AvrahamL · Accepted Answer · 2018-02-20 12:22:46Z

2

I belive you need to mention the name of the field, before the sub-field ("records.label" instead of "label").

Try this one:

Update update = new Update().pull("records", new BasicDBObject("records.label","JAP"));

If this will not do, you may try:

Update update = new Update().pull("records", Collections.singletonMap("label", "JAP"));

answered Feb 20, 2018 at 12:22

AvrahamL

3115 silver badges17 bronze badges

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

3 Comments

Anna Over a year ago

Your second proposition works better, I get this as a result: WriteResult{n=1, updateOfExisting=true, upsertedId=null}. But it still doesn't save anything in the database :/

AvrahamL Over a year ago

Is "PersonEntity.class" an Enum(represent the ollection name)? Are you sure it reflects the name and nut the numeric value?

Anna Over a year ago

I was missing a @qualifier for my mongoOperations so it was saving in the wrong database. So using Collections.singletonMap("label", "JAP") resolved my problem. Thank you very much! wasted too much time in this.

Neel Rathod · Accepted Answer · 2018-02-21 06:15:05Z

First you need to define a schema as const

const Chat = require('./modules/chat/chatModel')

and your query is like this:

 Chat.update({ _id: ObjectId("5a79b8a6b2ba9a49359fa3c3"), }, { $pull: { records: { label: "ASH" }, }, });

Dila Gurung · Accepted Answer · 2021-07-27 10:06:14Z

I also witness same issue but this is little different from accepted answer.

Update update = new Update().pull("records", new BasicDBObject("label","JAP"));

As you already mentioned records in key , so you need not write "records.label"

Collectives™ on Stack Overflow

How to remove elements from nested object array?

3 Answers 3

3 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Related