Need to sort in $search

Mahendra_Madala · 2025-03-31T15:45:26.776Z

hey will the sort works for the string fields inside the $search stage for me only date fields are working and not the string fields

Michael_Lynn · 2025-03-31T15:49:33.520Z

Hey Mahendra, welcome!

Might be helpful for you to share the search index definition so we can provide a bit more focused response… You can view or edit it in the Atlas UI → Search tab → Indexes → Edit JSON

You’ll probably want to append a $sort stage AFTER your $search stage… something like:

  $search: {
    index: "default",
    text: {
      query: "example",
      path: "yourFieldName"
    }
  }
},
{
  $sort: {
    "yourFieldName": 1
  }
}

Erik_Hatcher · 2025-03-31T18:12:27.613Z

For sorting with $search, numeric and date field types are automatically mapped and available. String fields currently require explicit token type mapping so they are indexed properly for sort-ability. See https://www.mongodb.com/docs/atlas/atlas-search/sort/ for more details.

Erik_Hatcher · 2025-03-31T18:15:15.432Z

While your example, Michael, will work - there’s an impedence mismatch between $search and successive stages, and stages like $group and $sort that consume all documents could cause a big performance hit. It’s best when using $search and needing to sort to do so with the sort options within the $search stage.

system · 2025-04-07T13:29:38.166Z

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.

Mahendra_Madala · 2025-04-07T14:17:54.511Z

thank you this worked

Mahendra_Madala · 2025-04-07T14:18:06.344Z

I’m currently working with a MongoDB collection where we have a field named customAttributes, which contains dynamic subfields that vary from customer to customer.

We are trying to enable wildcard search on these dynamic subfields using Atlas Search. Since the keys inside customAttributes are not consistent across documents, we attempted to use a dynamic mapping with wildcard support.

Could you please confirm the correct syntax for the search index definition that would:

Enable wildcard search on all subfields inside customAttributes
Work with dynamic keys
Use the appropriate keyword analyzer to support wildcard queries

If possible, could you share a sample index definition that would meet the above requirements?

my main need is to make it work like contains operator that can search with special character’s tooo