# Elastic Search searchAfter funcitonality not working

**URL:** https://discuss.elastic.co/t/elastic-search-searchafter-funcitonality-not-working/332561
**Category:** Elasticsearch
**Created:** [May 4, 2023, 1:44pm UTC](https://discuss.elastic.co/t/elastic-search-searchafter-funcitonality-not-working/332561 "2023-05-04T13:44:56Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![suresh\_chaudhari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/suresh_chaudhari/32/106602_2.png) [@suresh\_chaudhari](https://discuss.elastic.co/u/suresh_chaudhari)
#### Post date: [May 4, 2023, 1:44pm UTC](https://discuss.elastic.co/t/elastic-search-searchafter-funcitonality-not-working/332561/1 "2023-05-04T13:44:56Z")

</div>

Hi I am using the Elasticsearch 8 java client.  
I have created one field createdtime which stores epoch timestamp.

Now I first send one request like this

query:{ widcard:{name:foo}.  
sort:[creattedtime,asc]

it returns sort searchafter object which I will send for subsequent request.

It just gives up sayinng shard [es/search] failed: [search\_phase\_execution\_exception] all shards failed

---

<div class="post-metadata">

### Author: ![suresh\_chaudhari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/suresh_chaudhari/32/106602_2.png) [@suresh\_chaudhari](https://discuss.elastic.co/u/suresh_chaudhari)
#### Post date: [May 4, 2023, 1:58pm UTC](https://discuss.elastic.co/t/elastic-search-searchafter-funcitonality-not-working/332561/2 "2023-05-04T13:58:56Z")

</div>

````plaintext
    "_source": {
        "includes": ["createtime", "name"]
    },
    "query": {
        "bool": {
            "must": [{
                "wildcard": {
                    "name.keyword": {
                        "value": "*foo*"
                    }
                }
            }, {
                "bool": {
                    "should": [{
                        "match": {
                            "code": {
                                "query": 2
                            }
                        }
                    }, {
                        "match": {
                            "code": {
                                "query": 3
                            }
                        }
                    }]
                }
            }],
            "must_not": [],
            "should": []
        }
    },
    "size": 500,
    "sort": [{
        "createtime": {
            "order": "asc"
        }
    }]
}``` Query generated by elastic8 Java client.
````

---

<div class="post-metadata">

### Author: ![suresh\_chaudhari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/suresh_chaudhari/32/106602_2.png) [@suresh\_chaudhari](https://discuss.elastic.co/u/suresh_chaudhari)
#### Post date: [May 4, 2023, 2:52pm UTC](https://discuss.elastic.co/t/elastic-search-searchafter-funcitonality-not-working/332561/3 "2023-05-04T14:52:47Z")

</div>

COUNT query count not equal to number of records I got using Searchafter funcitonality

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 1, 2023, 2:53pm UTC](https://discuss.elastic.co/t/elastic-search-searchafter-funcitonality-not-working/332561/4 "2023-06-01T14:53:31Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
