elasticsearch set sort order using querystring

73,792

Solution 1

Try sort=anio:desc.

See search API - uri request for a list of parameters.

Solution 2

To answer opensas question

elasticsearch set sort order using querystring

this feature is called as multilevel sorting.

Example query is

GET /_search
{
    "query" : {
        "filtered" : {
            "query":   { "match": { "tweet": "manage text search" }},
            "filter" : { "term" : { "user_id" : 2 }}
        }
    },
    "sort": [
        { "date":   { "order": "desc" }},
        { "_score": { "order": "desc" }}
    ]
}

Order is important. Results are sorted by the first criterion first. Only results whose first sort value is identical will then be sorted by the second criterion, and so on. http://www.elasticsearch.org/guide/en/elasticsearch/guide/current/_sorting.html#_multilevel_sorting

Share:
73,792
opensas
Author by

opensas

Updated on August 26, 2021

Comments

  • opensas
    opensas over 2 years

    I have the following simple elastisearch query:

    http://localhost:9200/apn/presupuesto/_search?q=subcuenta:penal&sort=anio
    

    And it works fine

    Now I'm trying to order by anio desc. I tried with all these options:

    ...l&sort=anio desc
    
    ...l&sort=-anio
    
    ...l&sort=anio&order=desc
    

    But none of them seemed to work

    How can I achieve it? (ideally, from the querystring, without having to use a more complex query)