Currently, I have a collection named users, which contains the following documents:
Document 1:
{
"_id": {
"$oid": "5934fd84d6ba4c241259bed1"
},
"first_name": "Joe",
"last_name": "Smith",
"username": "jsmith",
"email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="8ee4fde3e7fae6ceebf1fdf5f0b6fbf7f5">[email protected]</a>",
"password": "$2a$10$eyIbahYKETTtP.i6WlyYd.QeqGNWswW1y/H/aOWw8euFDmWz.wwH2",
"gender": "male",
"messages": [
{
"$oid": "5937a1118ca79a02a6d10b11"
}
],
"__v": 16
}
Document 2:
{
"_id": {
"$oid": "5934fe100b557624207db665"
},
"first_name": "Sarah",
"last_name": "Smith",
"username": "tsmith",
"email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="87f3f4eaeef3efc7e0eae6eeeba9e4e8ea">[email protected]</a>",
"password": "$2a$10$hfPXLRU4wu2i0/HiVCXO5e2k4ORTsJGZhJ63OpU9OsfTz7JJYRnDS",
"gender": "female",
"messages": [
{
"$oid": "5937a1118ca79a02a6d10b11"
}
],
"__v": 25
}
My objective is to iterate through the entire collection and remove the contents of the messages array while retaining the key. Even though there are only 2 documents in this collection, I intend to perform this action on any number of documents.
The desired structure of the document post-iteration should be as follows:
{
"_id": {
"$oid": "5934fd84d6ba4c241259bed1"
},
"first_name": "Joe",
"last_name": "Smith",
"username": "jsmith",
"email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="a8c2dbc5c1dcc0e8cfc5c9c1c486cbc7c5">[email protected]</a>",
"password": "$2a$10$eyIbahYKETTtP.i6WlyYd.QeqGNWswW1y/H/aOWw8euFDmWz.wwH2",
"gender": "male",
"messages": [],
"__v": 16
}
I attempted to achieve this using the command
db.users.updateMany({}, { $set: { "messages": []}})E QUERY TypeError: Property 'updateMany' of object my_match.users is not a function<
filter> parameter in updateMany() since I wish to update all documents in the collection, as per the guiding principle in the MongoDB documentation: "Specify an empty document { } to update all documents in the collection."
While I could manually execute the updates using
db.users.update({first_name: "Joe"}, { $set: { "messages": []}})