elasticsearch set sort order using querystring

Question

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)

thanks a lot Diego, please enter it as an answer so I can accept it! — opensas
– opensas, Commented Dec 15, 2012 at 19:08
BTW, anybody knows how to order by several fields, like anio, cuenta, subcuenta??? from que querystring — opensas
– opensas, Commented Dec 15, 2012 at 19:08
@opensas: Just add more sort parameters. They will be applied in order given in URI. — Yuri
– Yuri, Commented Feb 21, 2017 at 13:08

Diego Basch · Accepted Answer · 2012-12-15 19:13:53Z

64

Try sort=anio:desc.

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

answered Dec 15, 2012 at 19:13

Diego Basch

13.1k2 gold badges31 silver badges24 bronze badges

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

2 Comments

Punit Gajjar Over a year ago

Godd Job Buddy,. Do you know if we can use a GroupBy in Query string ? Also i want to Count with GroupBy. is it possible ?

Marcosaurios Over a year ago

Link seems broken, check elastic.co/guide/en/elasticsearch/reference/6.8/…

Community · Accepted Answer · 2017-05-23 12:02:51Z

21

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

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Dec 30, 2014 at 8:02

Vinay Vemula

4,0051 gold badge24 silver badges24 bronze badges

Comments

Sergei Afanasenko · Accepted Answer · 2023-01-31 08:39:54Z

0

A simple example of how to sort indices in Management -> Dev Tools:

GET _cat/indices?s=index:desc

answered Jan 31, 2023 at 8:39

Sergei Afanasenko

11 bronze badge

Collectives™ on Stack Overflow

elasticsearch set sort order using querystring

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related