# Sort in Java API client

**URL:** <https://discuss.elastic.co/t/sort-in-java-api-client/305368>\
**Category:** Elasticsearch\
**Created:** [May 23, 2022, 4:59am UTC](https://discuss.elastic.co/t/sort-in-java-api-client/305368 "2022-05-23T04:59:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vishalop0993](https://avatars.discourse-cdn.com/v4/letter/v/9d8465/32.png) [@vishalop0993](https://discuss.elastic.co/u/vishalop0993)\
**Post date:** [May 23, 2022, 4:59am UTC](https://discuss.elastic.co/t/sort-in-java-api-client/305368/1 "2022-05-23T04:59:21Z")

</div>

Hi Experts,

I am using new java API client to connect with Elasticsearch. My requirement is to search documents in sorted order of given parameters.

I have written the below code to search and sort by "customer".

```auto
        SortOptions sort = new SortOptions.Builder().field(f -> f.field("customer").order(SortOrder.Asc)).build();
        List<SortOptions> list = new ArrayList<SortOptions>();
        list.add(sort);

        SearchResponse<Order> response = elasticsearchClient.search(b -> b.index("order").size(100).sort(list)
                .query(q -> q.bool(bq -> bq
                        .filter(fb -> fb.range(r -> r.field("orderTime").
                                        gte(JsonData.of(timeStamp("01-01-2022-01-01-01")))
                                        .lte(JsonData.of(timeStamp("01-01-2022-01-01-10")))
                                )
                        )
                        .must(query)
                )), Order.class);

```

I am getting below Exception.'

```auto
Exception in thread "main" co.elastic.clients.elasticsearch._types.ElasticsearchException: [es/search] failed: [search_phase_execution_exception] all shards failed
	at co.elastic.clients.transport.rest_client.RestClientTransport.getHighLevelResponse(RestClientTransport.java:281)
	at co.elastic.clients.transport.rest_client.RestClientTransport.performRequest(RestClientTransport.java:147)
	at co.elastic.clients.elasticsearch.ElasticsearchClient.search(ElasticsearchClient.java:1487)
	at co.elastic.clients.elasticsearch.ElasticsearchClient.search(ElasticsearchClient.java:1504)
	at model.OrderDAO.fetchRecordsQuery(OrderDAO.java:128)
	at model.OrderDAO.main(OrderDAO.java:45)

```

**Same code work if I remove .sort() method.**  
Please let me know what is wrong with the parameter being passed in .sort() method and help me with the correct syntax for sorting.

---

<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 20, 2022, 4:59am UTC](https://discuss.elastic.co/t/sort-in-java-api-client/305368/2 "2022-06-20T04:59:26Z")

</div>

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