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

0

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"
                },
            },
        });

answered Feb 21, 2018 at 6:15

Neel Rathod

2,11115 silver badges29 bronze badges

Comments

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

0

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"

answered Jul 27, 2021 at 10:06

Dila Gurung

1,78421 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to remove elements from nested object array?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related