Question 117266 in Mongodb Question posted in
The official documentation can be found here.

Deleting a multiple documents in a MongoDB collection by a nested array element

I am new to Mongo and I have a question about deleting documents using PyMongo.

I have a collection called mycollection. It has documents looking like this:

{
    "field1":"value1",
    "field2":"value2",
    "array_field": [
        "id1",
        "id2
    ]
}

I want to delete all documents in the collection which has id1 in the array_field.

How can I do this? (I am using PyMongo, I would appreciate examples based on it 🙂 )

Tags:

2

Answers


  1. 0

    this should do

    import pymongo

client = pymongo.MongoClient("mongodb://localhost:27017/")

mydb = client["DATABASE"]
col = mydb["mycoll"]
 
query = {"array_field": "id1"}
d = col.delete_many(query)
 
print(f"{d.deleted_count} documents deleted")
    Login or Signup to reply.
  2. 0 
       db.collection.deleteMany({
      "array_field": {
        $in: [
          "id1"
        ]
      }
    })

    Check the mongoplayground link: https://mongoplayground.net/p/nkhSCRyR9K-

    https://www.mongodb.com/docs/manual/reference/operator/query/

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search