Within an array, remove an item from an array within each object that item appears in

Question

My mongodb document(table) 'Org_unit' looks like this:

{
    "_id": ObjectId("0894f016e6e2e073c19e051")
    "allowedusers": [
        "admin",
        "Fred",
        "Bob",
        "Layneh"
    ],
    "name": "News management",
    "divisions": [
        {
            "allowedusers": [
                "admin",
                "Larry",
                "Bob",
                "Harry",
                "Fred"
            ],
            "_id": ObjectId("60894f016e6e2e073c19e052"),
            "name": "Finances",
            "credentials": [
                {
                    "_id": ObjectId("94f0944f016e6e2e2342cc"),
                    "name": "FNB - FA",
                    "userName": "[email protected]",
                    "password": "examplePassword!@#"
                }
            ]
        },
        {
            "allowedusers": [
                "admin",
                "Larry",
                "Bob",
                "Harry",
                "Fred"
            ],
            "_id": ObjectId("60894f016e6e2e073c19e052"),
            "name": "Development",
            "credentials": [
                {
                    "_id": ObjectId("94f0944f016e6e2e2342cc"),
                    "name": "FNB - DEV",
                    "userName": "[email protected]",
                    "password": "examplePassword!@#"
                }
            ]
        }
    ],
    "__v": 11
}

This is my fist post here, hello! Ok so I have been at this for a few days now and I just cant get this right.

What I am trying to do:

Within the "divisions" array, I want to remove "Fred" from the "allowedusers" array in each object "division" that he appears in.

What I have tried

I am still very new, about a week in. I have tried many times, but the closest I have gotten was this:

Org_unit.updateMany({name: "News management"}, { $pull: {'divisions': {'allowedusers': "Fred"}}},{ multi: true })

^^ This deleted the entire division if he appeared in its "allowedusers" array

Any guidance with this is massively appreciated Thank you in advance.

PS: (Since this is my first question posted, please let me know how I can improve my questions in the future!)

anubhava · Accepted Answer · 2021-05-01 07:27:50Z

1

Demo - https://mongoplayground.net/p/kR_NmQNO52y

Use $[]

The all positional operator $[] indicates that the update operator should modify all elements in the specified array field.

db.collection.update({
  name: "News management"
},
{
  $pull: {
    "divisions.$[].allowedusers": "Fred"
  }
})

edited May 1, 2021 at 7:27

anubhava

790k67 gold badges603 silver badges671 bronze badges

answered Apr 30, 2021 at 1:46

Tushar Gupta - curioustushar

57.2k24 gold badges106 silver badges110 bronze badges

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

1 Comment

Layne74 Over a year ago

Thank you so much! Seems I need to do more document digging on $.

Collectives™ on Stack Overflow

Within an array, remove an item from an array within each object that item appears in

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related