• MongoDB CRUD Operations >
• Query Documents >
• Query for Null or Missing Fields

Query for Null or Missing Fields

This page provides examples in:

Different query operators in MongoDB treat null values differently.

• Mongo Shell
• Compass
• Python
• Java (Sync)
• Node.js
• Other
  • PHP
  • Motor
  • Java (Async)
  • C#
  • Perl
  • Ruby
  • Scala
  • Go

This page provides examples of operations that query for null values using the db.collection.find() method in the mongo shell. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using MongoDB Compass. The examples on this page use the inventory collection. Populate the inventory collection with the following documents:

This page provides examples of operations that query for null values using the pymongo.collection.Collection.find() method in the PyMongo Python driver. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the com.mongodb.client.MongoCollection.find method in the MongoDB Java Synchronous Driver.

Tip

The driver provides com.mongodb.client.model.Filters helper methods to facilitate the creation of filter documents. The examples on this page use these methods to create the filter documents.

The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the Collection.find() method in the MongoDB Node.js Driver. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the MongoDB\Collection::find() method in the MongoDB PHP Library. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the motor.motor_asyncio.AsyncIOMotorCollection.find() method in the Motor driver. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the com.mongodb.reactivestreams.client.MongoCollection.find method in the MongoDB Java Reactive Streams Driver.

The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the MongoCollection.Find() method in the MongoDB C# Driver. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the MongoDB::Collection::find() method in the MongoDB Perl Driver. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the Mongo::Collection#find() method in the MongoDB Ruby Driver. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the collection.find() method in the MongoDB Scala Driver. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

This page provides examples of operations that query for null values using the Collection.Find function in the MongoDB Go Driver. The examples on this page use the inventory collection. To populate the inventory collection, run the following:

• Python
• Motor
• C#
• Perl
• Ruby
• Other
  • Scala
  • Go

Important

Use None with the PyMongo Python driver to query for null or missing fields in MongoDB.

Important

Use None with the Motor driver to query for null or missing fields in MongoDB.

Important

Use BsonNull.Value with the MongoDB C# driver to query for null or missing fields in MongoDB.

Important

Use undef with the MongoDB Perl driver to query for null or missing fields in MongoDB.

Important

Use nil with the MongoDB Ruby driver to query for null or missing fields in MongoDB.

Important

Use BsonNull() with the MongoDB Scala driver to query for null or missing fields in MongoDB.

Important

Use nil with the MongoDB Go driver to query for null or missing fields in MongoDB.

• Mongo Shell
• Compass
• Python
• Java (Sync)
• Node.js
• Other
  • PHP
  • Motor
  • Java (Async)
  • C#
  • Perl
  • Ruby
  • Scala
  • Go

copy

db.inventory.insertMany([
   { _id: 1, item: null },
   { _id: 2 }
])

You can run the operation in the web shell below:

copy

[
   { _id: 1, item: null },
   { _id: 2 }
]

For instructions on inserting documents in MongoDB Compass, see Insert Documents.

copy

db.inventory.insert_many([{"_id": 1, "item": None}, {"_id": 2}])

copy

collection.insertMany(asList(
        Document.parse("{'_id': 1, 'item': null}"),
        Document.parse("{'_id': 2}")
));

copy

await db.collection('inventory').insertMany([{ _id: 1, item: null }, { _id: 2 }]);

copy

$insertManyResult = $db->inventory->insertMany([
    ['_id' => 1, 'item' => null],
    ['_id' => 2],
]);

copy

await db.inventory.insert_many([{"_id": 1, "item": None}, {"_id": 2}])

copy

Publisher<Success> insertManyPublisher = collection.insertMany(asList(
        Document.parse("{'_id': 1, 'item': null}"),
        Document.parse("{'_id': 2}")
));

copy

var documents = new[]
{
    new BsonDocument { { "_id", 1 }, { "item", BsonNull.Value } },
    new BsonDocument { { "_id", 2 } }
};
collection.InsertMany(documents);

copy

$db->coll("inventory")->insert_many( [ { _id => 1, item => undef }, { _id => 2 } ] );

copy

client[:inventory].insert_many([{ _id: 1, item: nil },
                                { _id: 2 }])

copy

collection.insertMany(Seq(
  Document("""{"_id": 1, "item": null}"""),
  Document("""{"_id": 2}""")
)).execute()

copy

docs := []interface{}{
	bson.D{
		{"_id", 1},
		{"item", nil},
	},
	bson.D{
		{"_id", 2},
	},
}

result, err := coll.InsertMany(context.Background(), docs)

Equality Filter

• Mongo Shell
• Compass
• Python
• Java (Sync)
• Node.js
• Other
  • PHP
  • Motor
  • Java (Async)
  • C#
  • Perl
  • Ruby
  • Scala
  • Go

The { item : null } query matches documents that either contain the item field whose value is null or that do not contain the item field.

The { item : null } query matches documents that either contain the item field whose value is null or that do not contain the item field.

The { item : None } query matches documents that either contain the item field whose value is null or that do not contain the item field.

The eq("item", null) query matches documents that either contain the item field whose value is null or that do not contain the item field.

The { item : null } query matches documents that either contain the item field whose value is null or that do not contain the item field.

The [ item => undef ] query matches documents that either contain the item field whose value is null or that do not contain the item field.

The { item : None } query matches documents that either contain the item field whose value is null or that do not contain the item field.

The eq("item", null) query matches documents that either contain the item field whose value is null or that do not contain the item field.

The Eq("item", BsonNull.Value) query using the FilterDefinitionBuilder.Eq() method matches documents that either contain the item field whose value is null or that do not contain the item field.

The { item => undef } query matches documents that either contain the item field whose value is null or that do not contain the item field.

The { item => nil } query matches documents that either contain the item field whose value is nil or that do not contain the item field.

The equal("item", BsonNull) query matches documents that either contain the item field whose value is null or that do not contain the item field.

The item => nil query matches documents that either contain the item field whose value is nil or that do not contain the item field.

• Mongo Shell
• Compass
• Python
• Java (Sync)
• Node.js
• Other
  • PHP
  • Motor
  • Java (Async)
  • C#
  • Perl
  • Ruby
  • Scala
  • Go

copy

db.inventory.find( { item: null } )

Copy the following query filter document into the query bar and click Find:

copy

{ item: null }

copy

cursor = db.inventory.find({"item": None})

copy

FindIterable<Document> findIterable = collection.find(eq("item", null));

copy

const cursor = db.collection('inventory').find({
  item: null
});

copy

$cursor = $db->inventory->find(['item' => null]);

copy

cursor = db.inventory.find({"item": None})

copy

FindPublisher<Document> findPublisher = collection.find(eq("item", null));

copy

var filter = Builders<BsonDocument>.Filter.Eq("item", BsonNull.Value);
var result = collection.Find(filter).ToList();

copy

$cursor = $db->coll("inventory")->find( { item => undef } );

copy

client[:inventory].find(item: nil)

copy

var findObservable = collection.find(equal("item", BsonNull()))

copy

cursor, err := coll.Find(
	context.Background(),
	bson.D{
		{"item", nil},
	})

The query returns both documents in the collection.

Type Check

• Mongo Shell
• Compass
• Python
• Java (Sync)
• Node.js
• Other
  • PHP
  • Motor
  • Java (Async)
  • C#
  • Perl
  • Ruby
  • Go

The { item : { $type: 10 } } query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The { item : { $type: 10 } } query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The { item : { $type: 10 } } query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The type("item", BsonType.NULL) query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The { item : { $type: 10 } } query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The [ item => [ $type => 10 ] ] query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The { item : { $type: 10 } } query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The type("item", BsonType.NULL) query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The Type("item", BsonType.Null) query using the FilterDefinitionBuilder.Type() method matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The { item => { $type => 10 } } query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The { item => { $type => 10 } } query matches only documents that contain the item field whose value is null; i.e. the value of the item field is of BSON Type Null (type number 10) :

The following query matches only documents that contain the item field whose value is of BSON Type Null (type number 10) :

• Mongo Shell
• Compass
• Python
• Java (Sync)
• Node.js
• Other
  • PHP
  • Motor
  • Java (Async)
  • C#
  • Perl
  • Ruby
  • Scala
  • Go

copy

db.inventory.find( { item : { $type: 10 } } )

Copy the following query filter document into the query bar and click Find:

copy

{ item : { $type: 10 } }

copy

cursor = db.inventory.find({"item": {"$type": 10}})

copy

findIterable = collection.find(type("item", BsonType.NULL));

copy

const cursor = db.collection('inventory').find({
  item: { $type: 10 }
});

copy

$cursor = $db->inventory->find(['item' => ['$type' => 10]]);

copy

cursor = db.inventory.find({"item": {"$type": 10}})

copy

findPublisher = collection.find(type("item", BsonType.NULL));

copy

var filter = Builders<BsonDocument>.Filter.Type("item", BsonType.Null);
var result = collection.Find(filter).ToList();

copy

$cursor = $db->coll("inventory")->find( { item => { '$type' => 10 } } );

copy

client[:inventory].find(item: { '$type' => 10 })

copy

findObservable = collection.find(bsonType("item", BsonType.NULL))

copy

cursor, err := coll.Find(
	context.Background(),
	bson.D{
		{"item", bson.D{
			{"$type", 10},
		}},
	})

The query returns only the document where the item field has a value of null.

Existence Check

The following example queries for documents that do not contain a field. [1]

• Mongo Shell
• Compass
• Python
• Java (Sync)
• Node.js
• Other
  • PHP
  • Motor
  • Java (Async)
  • C#
  • Perl
  • Ruby
  • Scala

The { item : { $exists: false } } query matches documents that do not contain the item field:

The { item : { $exists: false } } query matches documents that do not contain the item field:

The { item : { $exists: False } } query matches documents that do not contain the item field:

The exists("item", false) query matches documents that do not contain the item field:

The { item : { $exists: false } } query matches documents that do not contain the item field:

The [ item => [ $exists => false ] ] query matches documents that do not contain the item field:

The { item : { $exists: False } } query matches documents that do not contain the item field:

The exists("item", false) query matches documents that do not contain the item field:

The Exists("item", false) query using the FilterDefinitionBuilder.Exists() method matches documents that do not contain the item field:

The { item => { $exists => false } } query matches documents that do not contain the item field:

The { item => { $exists => false } } query matches documents that do not contain the item field:

The exists("item", exists = false) query matches documents that do not contain the item field:

• Mongo Shell
• Compass
• Python
• Java (Sync)
• Node.js
• Other
  • PHP
  • Motor
  • Java (Async)
  • C#
  • Perl
  • Ruby
  • Scala
  • Go

copy

db.inventory.find( { item : { $exists: false } } )

Copy the following query filter document into the query bar and click Find:

copy

{ item : { $exists: false } }

copy

cursor = db.inventory.find({"item": {"$exists": False}})

copy

findIterable = collection.find(exists("item", false));

copy

const cursor = db.collection('inventory').find({
  item: { $exists: false }
});

copy

$cursor = $db->inventory->find(['item' => ['$exists' => false]]);

copy

cursor = db.inventory.find({"item": {"$exists": False}})

copy

findPublisher = collection.find(exists("item", false));

copy

var filter = Builders<BsonDocument>.Filter.Exists("item", false);
var result = collection.Find(filter).ToList();

copy

# For boolean values, use boolean.pm for 'true' and 'false'
$cursor = $db->coll("inventory")->find( { item => { '$exists' => false } } );

copy

client[:inventory].find(item: { '$exists' => false })

copy

findObservable = collection.find(exists("item", exists = false))

copy

cursor, err := coll.Find(
	context.Background(),
	bson.D{
		{"item", bson.D{
			{"$exists", false},
		}},
	})

The query only returns the document that does not contain the item field.

See also

Reference documentation for the $type and $exists operators.

[1]	Starting in MongoDB 4.2, users can no longer use the query filter $type: 0 as a synonym for $exists:false. To query for null or missing fields, see Query for Null or Missing Fields.

←   Project Fields to Return from Query Iterate a Cursor in the mongo Shell  →

© MongoDB, Inc 2008-present. MongoDB, Mongo, and the leaf logo are registered trademarks of MongoDB, Inc.