Elasticsearch sort by nested object

Question

i'm just discovering elasticsearch and i'm trying to make my first queries. for example in my case, each article has several prices, I would like to sort these articles by minimum price. and therefore I would not take the other ones into consideration. it is only the minimum prices that will have to sort my articles.
here are my articles :

{
           "name": "john",
           "prices": [
              {
                 "price": "22"
              },
              {
                 "price": "28"
              },
              {
                 "price": "8"
              }
           ]
        },
        {
           "name": "peter",
           "prices": [
              {
                 "price": "7"
              },
              {
                 "price": "5"
              },
              {
                 "price": "2"
              }
           ]
        },
        {
           "name": "billy",
           "prices": [
              {
                 "price": "15"
              },
              {
                 "price": "17"
              }
           ]
        }

smnh · Accepted Answer · 2017-10-22 00:05:11Z

1

POST /_search

{
    "query" : {
        "match_all": {}
    },
    "sort" : [
        {
            "prices.price": {
                "order": "asc",
                "mode" : "min"
            }
        }
    ]
}

Note: If your prices objects are of nested type (and not object) then you also need to add the "nested_path": "prices" inside the prices.price.

More info on sorting can be found here: https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-sort.html

answered Oct 22, 2017 at 0:05

smnh

1,74510 silver badges15 bronze badges

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

2 Comments

Manish sharma Over a year ago

may be we need to use GET method instead of POST , If yes so please update your answer

smnh Over a year ago

@Manishsharma ElasticSearch supports both GET and POST HTTP methods in Search API. And because in our example we are also sending data inside the body of the request, it should be POST, and not GET. Because GET, should not be used to send data in request body - developer.mozilla.org/en-US/docs/Web/HTTP/Methods/GET

Collectives™ on Stack Overflow

Elasticsearch sort by nested object

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related