MongoDB how to remove field inside embedded array?

Question

I have a situation where i want to remove a field inside a array of dictionary.

I know how to remove a normal field: { $unset: { : ""} }

But please help me for below example where i want to remove status field inside second dict

{  
    "recs":[  
        {  
            "required_1":""
            "required_2":"info",
            "status":"completed",
            "datetime":"2018-02-02T06:00:04Z"
        },
        {  
            "required_1":""
            "required_2":"info",
            "status":"inprogress"
            "datetime":"2018-02-02T06:00:04Z"         
        }
    ],
    "mainstatus":"failed"
}

Yes i want to delete from second dict. I want to delete if status is "inprogress" which is only there in second record — Avinash Hegde, Feb 28 '18 at 11:08
Possible duplicate of https://stackoverflow.com/questions/19945924/remove-a-field-from-all-elements-in-array-in-mongodb — chridam, Feb 28 '18 at 12:09

score 0 · Answer 1 · answered Feb 28 '18 at 10:56

0

You have to use the $ sign : recs.$.status will select the status field of all records in recs.

https://docs.mongodb.com/manual/reference/operator/update/positional/

answered Feb 28 '18 at 10:56

HRK44

2,382
2
13
30

Rahul Sharma · Answer 2 · 2018-03-01T09:10:15.047

-1

You have to use $pull to remove data from the array.

db.getCollection('TEST').update({/* some condition */}, {
    $pull: {
        recs: {"status" : "inprogress"}
    }
});

edited Mar 01 '18 at 09:10

answered Feb 28 '18 at 11:55

Rahul Sharma

9,534
1
15
37

MongoDB how to remove field inside embedded array?

2 Answers2