0

I am trying to translate the following elastic search query in Java, using the query builder? Can someone give any ideas of it?

GET <index-name>/_search
{
  “size”: 1,
  “sort”: [
  {
    “Date”: {
    “order”: “desc”
   }
  }
 ]
}
Marshmallow19
  • 1
  • 1
  • can you show us what you have tried already? – glenacota Mar 14 '21 at 12:34
  • This is what I have done so far: `SearchRequest sq = new SearchRequest(); searchRequest.indices(index); SearchSourceBuilder builder = new SearchSourceBuilder(); builder.size(1); builder.sort(new FieldSortBuilder("Date").order(SortOrder.DESC)); searchRequest.source(ssr);` – Marshmallow19 Mar 16 '21 at 00:34

1 Answers1

0

You need to use SortBuilder to sort on fields. Below request will sort Date field in desc order

    RestHighLevelClient client = new RestHighLevelClient(restClientBuilder);
    SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    searchSourceBuilder.size(1).sort(new FieldSortBuilder("Date").order(SortOrder.DESC));
    SearchRequest searchRequest = new SearchRequest("my-index");
    searchRequest.source(searchSourceBuilder);
    SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
ESCoder
  • 15,431
  • 2
  • 19
  • 42
  • @Marshmallow19 please go through the below answer, and let me know if this resolves your issue ? – ESCoder Apr 07 '21 at 12:12