Skip to Main Content

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.

Status Completed
Categories Atlas Search
Created by Guest
Created on Mar 24, 2020

I need to be able to search for dates and numbers in arrays

I have sets of results which contain dates and I need to be able to search from within them. For example: { experience: [ { name: "Abc", startDate: ISODate("2019-01-01T00:00:00.000Z"), startDate: ISODate("2020-01-01T00:00:00.000Z") }, { name: "Xyz", startDate: ISODate("2018-01-01T00:00:00.000Z"), startDate: ISODate("2019-01-01T00:00:00.000Z") } ] } So I need to be able to do a `near` search across `experience.startDate` values, for example. The Date mapping documentation (https://docs.atlas.mongodb.com/reference/atlas-search/index-definitions/#date) says: > A date cannot be indexed if it is part of an array. And while the number documentation doesn't mention the same restriction by experimentation I have found it has the same resriction (strings dont however). Essentially this feature request is to remove this restriction for dates and numbers.
  • ADMIN RESPONSE
    Oct 18, 2025
    Complete, view changelog ( https://www.mongodb.com/docs/atlas/atlas-search/changelog/#02-november-2022-release ) for more information
  • Guest
    Aug 31, 2022
    Hi All, I’m reaching out because this feature will be available for early access soon. If you’d like early access to this feature please review and respond to the email I sent today by EOD Friday, Sept 2nd and we’ll schedule you to receive access during the week of September 19th. Please keep in mind that delivery of this feature requires a reindexing of your collections - the email I sent has more details on what that entails and some additional information. Thanks!
  • Guest
    Oct 28, 2021
    +1 for Boolean support.
  • Guest
    Nov 10, 2020
    I found the problem to exist also for Boolean values inside an array object. I need it for filters during $search.