$count and $sort inside $search

icp · 2022-09-21T14:02:46.143Z

seems to be not possible right now, only can sort after search, which is slow

Daniel_Beaulieu · 2022-09-21T14:21:26.473Z

sorting on strings after $search is indeed slow. Atlas search results are sorted by relevance/score. You can boost the score to sort on numeric or date fields, but not on strings. For example, this will sort on createdDate descending

{
          $search: {
            compound: {
              should: [
                {
                  near: {
                    origin: new Date(),
                    path: 'createdOn',
                    pivot: 1,
                    score: { boost: { value: 999 } },
                  },
                },
              ],
            },
            count: { type: 'total' },
            index: 'default',
            returnStoredSource: true,
          },
        }

Marcus · 2022-12-05T21:34:56.625Z

We have a sort inside $search beta. Who would like to use it?

The best way to get to notified about it or receive the documentation is to go here as mentioned by @Elle_Shwer: Faster Sorting with Atlas Search – MongoDB Feedback Engine

Arjen_Devries · 2022-12-05T21:46:24.417Z

Yes! Please let me know how

Kyle_Mcarthur2 · 2022-12-05T22:48:32.764Z

Yessssssssss how do we use it?

KaMi_Lml · 2022-12-08T07:42:25.231Z

Hello Marcus, I did the form just now.

Please I am very interested in test the beta $sort function inside $search.

Currently we hace experimenting many timeouts request, or 20-30seconds in the best cases.

Elle_Shwer · 2022-12-13T20:31:39.356Z

@KaMi_Lml @Kyle_Mcarthur2 Did you see my email? I emailed about pagination, which is tightly integrated

Andrei_Batinas · 2023-02-09T14:03:46.929Z

Heeelo! Any news here?

Julien_Marginier · 2023-03-22T17:29:01.437Z

Hi, I did the form just now.
I am very interested to test the $sort function inside $search too.

Yi_Wang · 2023-05-22T23:52:51.186Z

Hello. We are facing the same issue with $sort and skip/limit after $search. This is blocking our development right now, due to some queries running more than 10s, while a response search for us needs to return in 2-3s.
Very eager to test the new sorting in Atlas search! Please add me to the list, thanks!

Dylan_Pierce · 2023-06-05T19:29:16.422Z

I’m also facing this issue in production.

Our high value clients that have many documents in our search index are impacted the most because of timeouts due to the pagination controls and sorting the documents by descending order.

Carlos_Garcia_Vega · 2023-06-07T08:44:18.724Z

we need a solution also with this topic. We need to sort the search query
Thanks in advance

Ed_Durguti · 2023-06-10T23:44:37.643Z

any update on this @Elle_Shwer ?

Elle_Shwer · 2023-06-14T11:28:49.191Z

Hi all, we have a GA sort solution coming VERY soon. Looking forward to announcing it.

Dylan_Pierce · 2023-06-14T13:19:31.724Z

Yes!!! Thank you! This issue is so painful for us and our customers.

Please let us know here in this thread in case I miss the email.

Elle_Shwer · 2023-07-17T18:28:01.126Z

Sort is GA, check it out here: https://www.mongodb.com/docs/atlas/atlas-search/sort/

It is only available on MongoDB version 6.0+ for sharded environments

Rakesh_Vidyadharan · 2023-07-18T18:58:43.189Z

Is it possible to specify a sort on the relevance score as well? If yes, would be great if the documentation included details and example. We have a situation where we would like to sort by the relevance (as default) and also specify reverse chronological order for matches with same relevance. Our index is mostly data, so we do end up with matches that have identical relevance.

Elle_Shwer · 2023-07-21T11:56:32.083Z

Sort by score is not yet supported but is on our short term roadmap. Feel free to file the request here: feedback.mongodb.com

Elle_Shwer · 2024-01-29T15:56:01.845Z

FYI Sort by Score is available. See here

Rakesh_Vidyadharan · 2024-01-29T17:42:36.541Z

Thanks, this feature works great