MongoDB: How to query for records where field is null or not set?

by

If the sent_at field is not there when its not set then:

db.emails.count({sent_at: {$exists: false}})

If it’s there and null, or not there at all:

db.emails.count({sent_at: null})

If it’s there and null:

db.emails.count({sent_at: { $type: 10 }})

The Query for Null or Missing Fields section of the MongoDB manual describes how to query for null and missing values.

Equality Filter

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

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

Existence Check

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

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

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

Type Check

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) :

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

More Related Contents:

  1. Get names of all keys in the collection
  2. How to filter array in subdocument with MongoDB [duplicate]
  3. Random record from MongoDB
  4. Query for documents where array size is greater than 1
  5. Find in Double Nested Array MongoDB
  6. MongoDB: upsert sub-document
  7. Conditional $sum in MongoDB
  8. arrayFilters in mongodb
  9. Get a count of total documents with MongoDB when using limit
  10. Include all existing fields and add new fields to document
  11. MongoDB aggregation comparison: group(), $group and MapReduce
  12. MongoDB group by array inner-elements
  13. Multiple Counts with single query in mongodb
  14. How to return array of string with mongodb aggregation
  15. How to return just the nested documents of an array from all documents
  16. MongoDB print distance between two points
  17. What is a Cursor in MongoDB?
  18. Mongodb aggregation $group, restrict length of array
  19. Get n-th element of an array in MongoDB
  20. Pull and addtoset at the same time with mongo
  21. Geospatial $near within current document field value
  22. How do I rename fields when performing search/projection in MongoDB?
  23. mongodb aggregation framework match by nested documents
  24. How to get back the new value after an update in a embedded array?
  25. How can I sort a Meteor collection by time of insertion?
  26. Mongodb, aggregate query with $lookup
  27. mongodb aggregate query isn’t returning proper sum on using $sum
  28. Return the last “true” value for each group
  29. MongoDB aggregate within daily grouping [duplicate]
  30. Cannot create index in mongodb, “key too large to index”

Leave a Comment