Sorting behavior and sorting sequence for mongodb

SAMRAT_N_A · 2024-06-18T14:11:44.941Z

Does MongoDB use a different sort sequence order when sorting within a $search operation compared to a normal sort operation?

case 1:

db.collection.aggregate([{
    $search: {
      index: "default_multi_sort",
      compound: {
        must: [
          {
            in: {
              path: "_id",
              value: [
               ObjectId("636cf2849d8e183db53aafca"),
               ObjectId("636cf2849d8e183db53aafcf"),
               ObjectId("636cf2849d8e183db53aafcd"),
               ObjectId("636cf2849d8e183db53aafce"),
              ],
            },
          },
        ],
      },
      sort: {
        name: 1,
      },
    },
  }],, {
            collation: {
                locale: "en",
                numericOrdering: true
            }
        })

case 2:

db.collection.aggregate([
 {
    $match:
      {
        _id: {
          $in: [
            ObjectId("636cf2849d8e183db53aafca"),
            ObjectId("636cf2849d8e183db53aafcf"),
            ObjectId("636cf2849d8e183db53aafcd"),
            ObjectId("636cf2849d8e183db53aafce"),
          ],
        },
      },
  },
  {
    $sort: {
      name: 1,
    },
  },
], {
  collation: {
    locale: "en",
    numericOrdering: true
  }
});```

In the first case, I receive numbers followed by alphabets, while in the second case, I receive a special character, then numbers, and finally alphabets. If this is true, how can I make them behave the same way?

below is my search index definition:
``

{
  "mappings": {
    "dynamic": true,
    "fields": {
      "name": [
            {
              "tokenization": "nGram",
              "type": "autocomplete",
              "analyzer": "lucene.keyword"
            },
            {
              "type": "token"
            }
          ],
         }
    }
}

steevej · 2024-06-18T14:44:14.281Z

The second aggregation is not valid. Please provide the actual code that you are testing.

SAMRAT_N_A · 2024-06-18T15:37:21.444Z

I have updated the question there was a mistake.

SAMRAT_N_A · 2024-06-28T10:33:43.157Z

Is there no one in this community with any recent knowledge or updates on this topic? I’ve been dealing with this problem for a while now.