MongoByte MongoDB Logo

Welcome to the new MongoDB Feedback Portal!

{Improvement: "Your idea"}
We’ve upgraded our system to better capture and act on your feedback.
Your feedback is meaningful and helps us build better products.

Add new feedback Subscribe
Status Completed
Categories Atlas Search
Created by Guest
Created on Sep 14, 2021

RELATED FEEDBACK

Allow indexing and querying for null datatype in Atlas Search

The *null* datatype is not amongst the [datatypes](https://docs.atlas.mongodb.com/reference/atlas-search/index-definitions/#bson-data-types) that Atlas Search supports at this time. As a result, if the use-case is to perform a text search on some fields and perform an equality/inequality check on other field(s) to see if it is/isn't *null*, then we need to have a *$match* stage following the *$search* stage, which is detrimental to the query performance [as documented here](https://docs.atlas.mongodb.com/reference/atlas-search/performance/#-match-aggregation-stage-usage). This is an enhancement request to allow indexing and querying for null datatype in Atlas Search, to avoid the above scenario.
  • ADMIN RESPONSE
    Oct 18, 2025
    This work is now complete. Update your search index ( https://www.mongodb.com/docs/atlas/atlas-search/rebuild-index/ ) to search for null using the Atlas Search equals ( https://www.mongodb.com/docs/atlas/atlas-search/equals/ ) operator on any field that is statically or dynamically indexed.
  • Guest
    Jun 27, 2023
    This feature is critical to our workflows of being able to filter under multiple criteria without performance setbacks. We'd love to have most of our filtering conditions happening through atlas search.
    Reply
  • Guest
    Feb 7, 2023
    Lack of this feature is preventing us for adopting Atlas Search
    Reply
  • Guest
    Jan 24, 2023
    Hello, Are there any plans to include this important feature in Atlas search? Thanks, Prasad
    Reply
  • Guest
    Aug 22, 2022
    This is a must which should be taken into consideration as a high priority. The $match impacts performance and using a combination/hacks of must, mustNot, range, equals make the query so ugly that it impacts the performance of person writing it.
    Reply
  • Guest
    Jul 5, 2022
    Null check filter is important. We are struggling to get some Mongo filters working on AtlasSearch without this. Hope to see this feature coming to AtlasSearch soon.
    Reply
  • Guest
    Nov 15, 2021
    This would be extremely helpful for fields that can either NOT exist or exist but be NULL. This feature would allow us to avoid using a $match aggregation stage after our $search.
    Reply