ElasticSearch Pagination & Sorting

Question

I am trying to sort search results by a date across multiple pages of results. Sorting is working within each page, is there a way to sort across the entire set?

For example: If page 1 has items from Feb 13 through Feb 1st; the second page should not have items after Feb 1st.

Here is a brief snippet of the request that I am sending. I have also tried sorting by date then _score, but that produced even stranger results (primarily, the sort order was the same).

{
  "query": {
    "from": 0,
    "size": 24
    "sort": [
      "published_on": {
        "missing": "_last",
        "ignore_unmapped": true,
        "order": "desc"
      }
    ]
    "custom_filters_score": {
      "query": {
        "bool": {
          "must": [
            {
              "match": {
                "content": "Some query"
              }
            }
          ]
          ... more ...
        }
      },
      "filters": [
        {
          "filter" => {
            "type" => {
              "value" => "cats"
            }
          },
          "boost" => 2
        }
        ... more ...
      ]
    }
  }
}

Any thoughts? Thanks in advance!

It should be date then _score. Please consider including your "strange" results in the question. Somebody might be able to explain why they are so strange. — imotov
– imotov, Commented Feb 14, 2013 at 2:48
As I said in the question I tried sorting by date then _score. I will try to put up some results today. — Jake
– Jake, Commented Feb 14, 2013 at 16:20
Sorry, I didn't read your comment well enough to catch what you are saying. As of right now the _sort is not in place and I am still seeing the same results. — Jake
– Jake, Commented Feb 14, 2013 at 20:36

ndrwnaguib · Accepted Answer · 2019-09-18 13:38:46Z

20

I was not multiplying the page index by the number of items on the page. I'm not sure how I missed the same entires on every page, moved up by a single spot.

I'm sure this will resolve all of the other odd issues that I have been dealing with.

edited Sep 18, 2019 at 13:38

ndrwnaguib

6,2463 gold badges33 silver badges56 bronze badges

answered Feb 15, 2013 at 16:36

Jake

7991 gold badge5 silver badges12 bronze badges

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

1 Comment

Paul d'Aoust Over a year ago

:-) We've all been in a similar spot, I'm sure.

Sergey Karasev · Accepted Answer · 2013-02-15 13:02:15Z

8

sort, size, from must be in the root

    {
       query:{
          ...
       },
       sort:[
         ...
       ],
       from:15,
       size:5
    }

Search API - Sort

answered Feb 15, 2013 at 13:02

Sergey Karasev

4,8944 gold badges27 silver badges24 bronze badges

1 Comment

user5876639 Over a year ago

hello sir please can you answer on my stackoverflow.com/questions/35719728/… it is also about pagination

Collectives™ on Stack Overflow

ElasticSearch Pagination & Sorting

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related