How to sort fields with elasticsearch 7

Question

I tried to sort results with a title but it didn't work properly.

Query :

GET /products/_search
{
        "sort": [
            { "title.keyword":   { "order": "desc" }}
          ],
        "query": {
           ....
        },

}

Mapping

"mappings" : {
      "properties" : {
        ...
        "title" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },
        ...
      }
    }

Results

{
  "took" : 3,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 826,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [
      {
        "_index" : "products",
        "_type" : "_doc",
        "_id" : "1457580605505",
        "_score" : null,
        "_source" : {
          "id" : 1457580605505,
          "title" : "Étui-portefeuille multifonction pour iPhone",  <-----
          "body_html" : "description here",

after googling I didn't found the right answer for my case. maybe because I'm using ES7 and solution giving not compatible with it.
I have multiple products start with Z...
thanks

add some of your data as well for a complete understanding

Satya
– Satya

2019-05-03 11:12:47 +00:00
Commented May 3, 2019 at 11:12 — Satya
– Satya, Commented May 3, 2019 at 11:12

Pierre Mallet · Accepted Answer · 2019-05-03 11:58:46Z

2

É is after Z in character sorting. ( É is different from E ). When you want to sort on some string in elastic you should apply a normalizer to your field to achieve natural sorting.

You should go to this documentation page : normalizer

In your case since you use french language, your normalizer should be composed of lowercase and ascii_folding filters. So the example in the documentation page should perfectly match your needs.

answered May 3, 2019 at 11:58

Pierre Mallet

7,2412 gold badges22 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to sort fields with elasticsearch 7

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related