Removing data from a subdocument in Mongodb

Question

Removing data from a subdocument in Mongodb

I've been encountering difficulties trying to remove a subdocument in mongoDb. Despite attempting methods like $update, $push, and $pull, I haven't had any success.

Here is the document in question:

db.users.findOne({"_id": ObjectId("545677a9e4b0e0ef9379993c")})
{
    "_class" : "com.xxx.xxx.server.da.User",
    "_id" : ObjectId("545677a9e4b0e0ef9379993c"),
    "bookSummaries" : [
        {
            "_id" : ObjectId("545677e7e4b0e0ef9379993d"),
            "isbn" : "2746969644"
            "title": "test title"
        },      
        {
            "_id" : ObjectId("546a522a44ae4f5e652fdca7"),           
            "loanSummaries" : [
                {
                    "loanStatus" : "REQUESTED",
                    "loanId" : "5473992044aec466a619290c"
                },
                {
                    "loanStatus" : "REQUESTED",
                    "loanId" : "5473997d44aec466a619290d"
                },
                {
                    "loanStatus" : "REQUESTED",
                    "loanId" : "547605a744ae0f0d558ae757"
                }
            ],
            "testArray" : [
                {
                    "title" : "Back to the future",
                    "id" : "test"
                },
                {
                    "title" : "Back to the future",
                    "id" : "test2"
                },
                {
                    "title" : "Back to the future",
                    "id" : "test3"
                },
                "test ",
                "test ",
                "test 2",
                "test 2",
                {
                    "loanStatus" : "REQUESTED"
                }
            ],
            "title" : "Back to the future"
        }
    ]
}

My goal is to generate queries for the following tasks:

Delete the entire "testArray" subdocument only within this specific subdocument
Delete a particular loanSummary based on its loanId within this specific subdocument

If anyone could assist me in crafting these queries, it would be greatly appreciated. I have searched through various posts but have not found a solution that fits my problem exactly.

Thank you very much

javascript mongodb spring-data-mongodb

Answer 1

Answer №1

Dealing with a similar issue, I encountered the need to eliminate a nested subarray. When handling the query, it is crucial to pinpoint the specific object for removal. In the update query, utilize the $ sign as an index to extract the desired object from the array.

var query = {
       "_id" : ObjectId(someUserId),
       "bookSummaries._id" : ObjectId(bookId),
       "bookSummaries.loanSummaries.loanId" : loanId
 };

var updateQuery = {
      "$pull" : {
          "bookSummaries.$.loanSummaries" : {
                 "loanId": loadId
          }
      }
}

Update

I executed these queries successfully in my shell. Remember to input the relevant ids.

var query = { "_id" : ObjectId("53b73b1108fe927c0e00007f"),  "bookSummaries._id" : ObjectId("53b73b1108fe927c0e00007f"), "bookSummaries.loanSummaries.loanId" : "53b73b1108fe927c0e00007f" }

var updateQuery = { "$pull" : { "bookSummaries.$.loanSummaries" : {  "loanId": "53b73b1108fe927c0e00007f"  } } }

Update 2

If you are aware of the index of the item/object to be removed, execute the following queries for achieving this.

Locate the document for editing

var query = {
   "_id" : ObjectId(someUserId),
};

Deselect the object to be eliminated

var update1 = {
  "$unset" : {
      "bookSummaries.1.loanSummaries.2" : 1
  }
}

Pull the object containing null value

var update2 = {
  "$pull" : {
      "bookSummaries.1.loanSummaries" : null
  }
}

To remove, utilize the same set of queries.

Locate the document for editing

var query = {
   "_id" : ObjectId(someUserId),
};

Deselect the object to be eliminated

var update1 = {
  "$unset" : {
      "bookSummaries.0.testArray" : 1
  }
}

Answer 2

Dealing with a similar issue, I encountered the need to eliminate a nested subarray. When handling the query, it is crucial to pinpoint the specific object for removal. In the update query, utilize the $ sign as an index to extract the desired object from the array.

var query = {
       "_id" : ObjectId(someUserId),
       "bookSummaries._id" : ObjectId(bookId),
       "bookSummaries.loanSummaries.loanId" : loanId
 };

var updateQuery = {
      "$pull" : {
          "bookSummaries.$.loanSummaries" : {
                 "loanId": loadId
          }
      }
}

Update

I executed these queries successfully in my shell. Remember to input the relevant ids.

var query = { "_id" : ObjectId("53b73b1108fe927c0e00007f"),  "bookSummaries._id" : ObjectId("53b73b1108fe927c0e00007f"), "bookSummaries.loanSummaries.loanId" : "53b73b1108fe927c0e00007f" }

var updateQuery = { "$pull" : { "bookSummaries.$.loanSummaries" : {  "loanId": "53b73b1108fe927c0e00007f"  } } }

Update 2

If you are aware of the index of the item/object to be removed, execute the following queries for achieving this.

Locate the document for editing

var query = {
   "_id" : ObjectId(someUserId),
};

Deselect the object to be eliminated

var update1 = {
  "$unset" : {
      "bookSummaries.1.loanSummaries.2" : 1
  }
}

Pull the object containing null value

var update2 = {
  "$pull" : {
      "bookSummaries.1.loanSummaries" : null
  }
}

To remove, utilize the same set of queries.

Locate the document for editing

var query = {
   "_id" : ObjectId(someUserId),
};

Deselect the object to be eliminated

var update1 = {
  "$unset" : {
      "bookSummaries.0.testArray" : 1
  }
}

Answer 3

Answer №2

When faced with a similar task, I had to remove several subdocuments rather than just one. My approach involved using an array of IDs to achieve this:

User.findOneAndUpdate(
      { _id: userId },
      {
        $pull: { documentList: { _id: { $in: idArray } } },
      });

Answer 4

When faced with a similar task, I had to remove several subdocuments rather than just one. My approach involved using an array of IDs to achieve this:

User.findOneAndUpdate(
      { _id: userId },
      {
        $pull: { documentList: { _id: { $in: idArray } } },
      });

Answer 5

Answer №3

With MongoDB's capability to offer a complete JavaScript environment, you have the flexibility to easily modify the document and update the data in the database.

*Please note: If you are utilizing MongoDB in conjunction with PHP or Python, there are similar methods available for accomplishing the same tasks.

1. To remove the entire "testArray" subdocument for a specific index (1) within this particular subdocument:

db.users.find({"_id": ObjectId("545677a9e4b0e0ef9379993c")}).forEach(function (user) {
    delete user.bookSummaries[1].testArray;
    // Saving the modifications 
    db.users.save(user);
 });

To eliminate a specific loanSummaries entry based on its loanId, such as id 5473992044aec466a619290c:

db.users.find({"_id": ObjectId("545677a9e4b0e0ef9379993c")}).forEach(function (user) {
    var loanToDelete = "5473992044aec466a619290c";
    var loanIndexToDelete = -1;

    var i;
    for(i in user.bookSummaries[1].loanSummaries) {
        if(user.bookSummaries[1].loanSummaries[i].loanId === loanToDelete) {
            loanIndexToDelete = i;
            break;
        }
    }

    if (loanIndexToDelete > -1) {
      delete user.bookSummaries[1].loanSummaries[loanIndexToDelete];
    }

    // Saving the changes
    db.users.save(users);
});

Answer 6

With MongoDB's capability to offer a complete JavaScript environment, you have the flexibility to easily modify the document and update the data in the database.

*Please note: If you are utilizing MongoDB in conjunction with PHP or Python, there are similar methods available for accomplishing the same tasks.

1. To remove the entire "testArray" subdocument for a specific index (1) within this particular subdocument:

db.users.find({"_id": ObjectId("545677a9e4b0e0ef9379993c")}).forEach(function (user) {
    delete user.bookSummaries[1].testArray;
    // Saving the modifications 
    db.users.save(user);
 });

To eliminate a specific loanSummaries entry based on its loanId, such as id 5473992044aec466a619290c:

db.users.find({"_id": ObjectId("545677a9e4b0e0ef9379993c")}).forEach(function (user) {
    var loanToDelete = "5473992044aec466a619290c";
    var loanIndexToDelete = -1;

    var i;
    for(i in user.bookSummaries[1].loanSummaries) {
        if(user.bookSummaries[1].loanSummaries[i].loanId === loanToDelete) {
            loanIndexToDelete = i;
            break;
        }
    }

    if (loanIndexToDelete > -1) {
      delete user.bookSummaries[1].loanSummaries[loanIndexToDelete];
    }

    // Saving the changes
    db.users.save(users);
});

Removing data from a subdocument in Mongodb

Answer №1

Update

Update 2

Answer №2

Answer №3

Similar questions

What is the best way to prevent the body from scrolling when scrolling on a fixed div without making the body's scroll bar disappear?

Ensuring that an added row remains at the bottom of a table composed of rows generated dynamically by utilizing the .detach() method

Incorporate PHP form and display multiple results simultaneously on a webpage with automatic refreshing

A new date picker applied to a dynamically generated form field

The architecture of Angular controllers

Error: React.createElement function requires a valid type parameter

Attempting to incorporate Google charts into a div using jQuery's load function

Searching for multiple white spaces in JavaScript to ensure that no empty data is transmitted and removing any excess spaces

changing up the format of nested blockquotes

Dramatist: Verifying DOM once printer dialogue appears

Display a tooltip when the user hovers over the column name of a BootstrapVue table

Create a dynamic select2 field based on the value selected in another dropdown menu

What is the best way to transmit UTF-8 Arrow → from typescript to html and showcase it effectively?

Locate the position of a substring within a Uint8Array

Retrieving Nearby Zip Codes using a JSON Rest API in AngularJS

Guide on how to add multiple options to a select element in HTML using prototype.js

Acquiring the markers, however the latitude and longitude are both null - vue.js

Types with conditions but no common parameter

Bring in numerous documents utilizing a glob pattern

Extracting information from a string with JSON in Javascript

Removing data from a subdocument in Mongodb

Answer №1

Update

Update 2

Answer №2

Answer №3

Similar questions

What is the best way to prevent the body from scrolling when scrolling on a fixed div without making the body's scroll bar disappear?

Ensuring that an added row remains at the bottom of a table composed of rows generated dynamically by utilizing the .detach() method

Incorporate PHP form and display multiple results simultaneously on a webpage with automatic refreshing

A new date picker applied to a dynamically generated form field

The architecture of Angular controllers

Error: React.createElement function requires a valid type parameter

Attempting to incorporate Google charts into a div using jQuery's load function

Searching for multiple white spaces in JavaScript to ensure that no empty data is transmitted and removing any excess spaces

changing up the format of nested blockquotes

Dramatist: Verifying DOM once printer dialogue appears

Display a tooltip when the user hovers over the column name of a BootstrapVue table

Create a dynamic select2 field based on the value selected in another dropdown menu

What is the best way to transmit UTF-8 Arrow &#8594; from typescript to html and showcase it effectively?

Locate the position of a substring within a Uint8Array

Retrieving Nearby Zip Codes using a JSON Rest API in AngularJS

Guide on how to add multiple options to a select element in HTML using prototype.js

Acquiring the markers, however the latitude and longitude are both null - vue.js

Types with conditions but no common parameter

Bring in numerous documents utilizing a glob pattern

Extracting information from a string with JSON in Javascript

What is the best way to transmit UTF-8 Arrow → from typescript to html and showcase it effectively?