Seeking out and upgrading essential information: how to do it effectively?

Question

Seeking out and upgrading essential information: how to do it effectively?

I am working with a document in a mongo collection that looks like this:

{

"_id" :"sdsfsfd323323323ssd",
"data" : {
        "('State', 'Get-Alert', 'BLIST_1', 'MessageData')" : [
            "$B_Add-Server", 
            "$B_Pool1_0_Server"
        ],
        "('State', \"Get-Server -Server 'uds412'\"):[
            "$B_Add-Server", 
            "$B_Pool2_0_Server"
          ]
}

and I need to change the value "uds412" to "newValue".

If anyone has a solution on how to find and replace it, please help!

Thank you

javascript json mongodb

Answer 1

Answer №1

To update a JSON object, you can convert it to a string, replace the desired value, and then parse it back into a valid JSON object.

jsonData={ ...YOUR JSON DATA... }

updatedData = JSON.parse(JSON.stringify(jsonData).replace('oldValue','newValue'))

Answer 2

To update a JSON object, you can convert it to a string, replace the desired value, and then parse it back into a valid JSON object.

jsonData={ ...YOUR JSON DATA... }

updatedData = JSON.parse(JSON.stringify(jsonData).replace('oldValue','newValue'))

Answer 3

Answer №2

After tackling the issue, I approached it with the following solution: the problem lied in the necessity of finding a substring from a key and then updating that key.

// To begin, query the document

db.server_col.find().forEach(function (docs) {

    var tempData = {};
    var tempDataAr = [];

    for (var key in docs["data"]) {

        var find = /'uds412'/;

        if (key.match(find)) {
            tempDataAr = docs["data"][key]
            key = key.replace('uds412', 'newValue');
            tempData[key] = tempDataAr;
        } else {
            tempData[key] = docs["data"][key];
        }

    }
   print(tempData);
   // Now proceed with the update
   db.server_col.update({ "_id" : ObjectId("sdfsfdafs")}, { $set: { 'data':tempData  } }, { multi: true })

});

Answer 4

After tackling the issue, I approached it with the following solution: the problem lied in the necessity of finding a substring from a key and then updating that key.

// To begin, query the document

db.server_col.find().forEach(function (docs) {

    var tempData = {};
    var tempDataAr = [];

    for (var key in docs["data"]) {

        var find = /'uds412'/;

        if (key.match(find)) {
            tempDataAr = docs["data"][key]
            key = key.replace('uds412', 'newValue');
            tempData[key] = tempDataAr;
        } else {
            tempData[key] = docs["data"][key];
        }

    }
   print(tempData);
   // Now proceed with the update
   db.server_col.update({ "_id" : ObjectId("sdfsfdafs")}, { $set: { 'data':tempData  } }, { multi: true })

});

Seeking out and upgrading essential information: how to do it effectively?

Answer №1

Answer №2

Similar questions

Developing a password strength checker using Javascript for ultimate security

What is the best way to filter out duplicate objects in JavaScript?

Enhance the connectivity of Angular js by activating the link function post transclusion

What is the best way to transfer data between different states in ReactJS components?

Trigger an email notification in Google Sheets whenever a designated cell is populated

Strategies for Handling a High Volume of API Requests in Node JS

Using Promise.all within the useEffect hook in ReactJS

Even with the use of setTimeout, Angular 5 fails to recognize changes during a lengthy operation

Is there a way to connect the select2 plugin to a select element that contains plugin options in a JSON object stored in the data attribute?

Having trouble creating a table using a JSON object in AngularJS

Find a specific row in a table using jQuery without requiring any input from the

What methods can I use to minimize the frequency of the blue box appearing around text?

Mutual TLS authentication and secure tunneling with ngrok

Query the number of Firebase instances using the firebase.appCount property in Firebase v

Tips for resolving the "trim" of undefined property error in Node.js

Save the file to a specific folder and compress the entire folder into a

Simple steps to transform an array of elements into an object within a MongoDB projection

Azure SQL Server linked with a REST API built on Express.js/Node.js encountered an error stating: "TypeError: req.sql is not a function"

What is the reason behind my page automatically scrolling to the bottom when it loads?

What is the process for retrieving and utilizing data from a previous MongoDB database stored on a secondary drive?