Set server status to inactive in a MongoDB collection with server records?

Let us create a collection with documents −

> db.demo707.insertOne(
...    {
...       id:101,
...       "serverInformation":
...       [
...          {
...             "IP":"192.56.34.3",
...             "Status":"Active"
...          },
...          {
...             "IP":"192.56.36.4",
...             "Status":"Inactive"
...          }
...       ]
...    }
... );
{
   "acknowledged" : true,
      "insertedId" : ObjectId("5ea6f852551299a9f98c93c8")
}

Display all documents from a collection with the help of find() method −

> db.demo707.find();

This will produce the following output −

{ "_id" : ObjectId("5ea6f852551299a9f98c93c8"), "id" : 101, "serverInformation" : [ { "IP" : "192.56.34.3", "Status" : "Active" }, { "IP" : "192.56.36.4", "Status" : "Inactive" } ] }

Following is the query to set active server to inactive status −

>db.demo707.update({"serverInformation.IP":"192.56.34.3"},{$set:{"serverInformation.$.Status":"Inactive"}});
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

Display all documents from a collection with the help of find() method −

> db.demo707.find();

This will produce the following output −

{ "_id" : ObjectId("5ea6f852551299a9f98c93c8"), "id" : 101, "serverInformation" : [ { "IP" : "192.56.34.3", "Status" : "Inactive" }, { "IP" : "192.56.36.4", "Status" : "Inactive" } ] }

AmitDiwan

Updated on 14-May-2020 09:55:33

• Related Questions & Answers
• MongoDB GroupBy to set status
• How can I check the status of MySQL Server?
• Select records with ACTIVE status in MySQL set with ENUM
• MySQL Server and Server-Startup Programs
• How To Set Up Multiple SSL Host With A Single Apache Server
• Get all embedded documents with “isMarried” status in a MongoDB collection
• How to Set-Up Shiny Server on Ubuntu
• Difference between Web Server and Application Server
• How to Configure Nagios Server for Monitoring Apache Server
• Creating a Node.js server
• Get the maximum mark records from a collection with documents in MongoDB
• Deleting all records of a collection in MongoDB Shell?
• MongoDB query to retrieve records from a collection named with letters and numbers
• Client Server Computing
• MongoDB Convert One record with an array to multiple records in a new collection?