How to remove a single array element in a specific object in mongodb? [duplicate]

Question

i need some help with my Mongo DB request.

This is my document structure:

{
 "username" : "firstUser",
 "email" : "[email protected]",
 "subscriptions" : [
     {
         "subscriptionId" : ObjectId("59f972dfdaca9e39487e3bb4"),
         "someOtherFields" : "otherValue",
         "message" : {
             "contact" : [
                 "[email protected]",
                 "[email protected]",
                 "[email protected]"
             ],
             "subject" : "Mailsubject",
             "content" : "Mailcontent"
          }
     },
     {
         "subscriptionId" : ObjectId("59faf26c8a593b25b8a9a8f7"),
         "someOtherFields" : "otherValue",
         "message" : {
             "contact" : [
                 "[email protected]",
                 "[email protected]",
                 "[email protected]"
             ],
             "subject" : "Mailsubject",
             "content" : "Mailcontent"
          }
     }
}

Now i need to remove one E-Mail address from the subscriptions.message.contact array, where the subscriptions.subscriptionid = ObjectId("59f972dfdaca9e39487e3bb4").

I tried something like this:

db.getCollection('myCollection').update({
"subscriptions.subscriptionId" : ObjectId("59f972dfdaca9e39487e3bb4")
},
{
    "$pull" : { "subscriptions": {"message.contact" : "[email protected]" }}
})

but it removed all subscriptions with this E-Mail address

Does anyone know, how to solve this problem?

Serkan Arslan · Accepted Answer · 2017-11-05 20:37:03Z

3

You can use this.

I used $ operator for identifying the elements in the subscriptions array.

db.getCollection('myCollection').update({
"subscriptions.subscriptionId" : ObjectId("59f972dfdaca9e39487e3bb4")
},
{
    "$pull" : {"subscriptions.$.message.contact" :"[email protected]"}
}
)

edited Nov 5, 2017 at 20:37

answered Nov 5, 2017 at 20:31

Serkan Arslan

13.4k4 gold badges33 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

How to remove a single array element in a specific object in mongodb? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related