How to select MongoDB document that does not consist a specific field?

Check for a specific field using MongoDB $exists. If that field does not exist in a document, then you need to display the same document with find().

Let us create a collection with documents −

> db.demo612.insertOne({id:1,"Info":[{Name:"Chris",Age:21},{Name:"David"}]});{
   "acknowledged" : true, "insertedId" : ObjectId("5e987372f6b89257f5584d87")
}

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

> db.demo612.find().pretty();

This will produce the following output −

{
   "_id" : ObjectId("5e987372f6b89257f5584d87"),
   "id" : 1,
   "Info" : [
      {
         "Name" : "Chris",
         "Age" : 21
      },
      {
         "Name" : "David"
      }
   ]
}

Following is the query to fetch a MongoDB document that does not consist of a specific field −

> db.demo612.aggregate({$unwind: "$Info"},
... {$match: {"Info.Age":{$exists: false}}},
... {$project: {"Info.Name": 1}})

This will produce the following output −

{ "_id" : ObjectId("5e987372f6b89257f5584d87"), "Info" : { "Name" : "David" } }

AmitDiwan

Published on 15-May-2020 08:08:37

• Related Questions & Answers
• MongoDB query to fetch a document that does not have a particular field?
• MongoDB query select and display only a specific field from the document?
• Find MongoDB documents that contains specific field?
• Select MongoDB documents where a field either does not exist, is null, or is false?
• Find documents that contains specific field in MongoDB?
• MongoDB query to determine if a specific value does not exist?
• MongoDB query to remove a specific document
• Find the document by field name with a specific value in MongoDB?
• Find document with array that contains a specific value in MongoDB
• How to add a field with specific datatype (list, object) in an existing MongoDB document?
• How to select a single field in MongoDB?
• How to select objects where an array contains only a specific field in MongoDB?
• How to remove a field completely from a MongoDB document?
• Find a strict document that contains only a specific field with a fixed length?
• How to select a specific subdocument in MongoDB?