Sortorder in Elasticsearch

Question

I have written elasticsearch query using java api in which status count is fetched per day.

Code:

SearchResponse responseOutput = client.prepareSearch(ConstantsValue.indexName)
.setTypes(ConstantsValue._Type)
.setFetchSource(new String[]{"STATUS", "DTCREATED"}, null)
.setQuery(
    QueryBuilders.filteredQuery(QueryBuilders.matchAllQuery(),
    FilterBuilders.rangeFilter("DTCREATED").from(fromDate).to(toDate))).
    addAggregation(AggregationBuilders.terms("STATUS_AGG").field("STATUS")
        .subAggregation(AggregationBuilders.dateHistogram("DATE_AGG").field("DTCREATED").interval(DateHistogram.Interval.DAY).format("yyyy-MM-dd"))
        )
       .addSort("DTCREATED", SortOrder.ASC)
       .get();

I am trying to sort data by DTCREATED field which contains both date and time but query does not provide sorted result. I can't find what I am missing in query. Any help ?

Are you getting any error or exception ? – Kulasangar Nov 29 '16 at 10:38 — Kulasangar, Nov 29 '16 at 10:38

score 0 · Answer 1 · edited Nov 29 '16 at 12:50

0

What if you have your .addSort as below:

.addSort(SortBuilders.fieldSort("DTCREATED").order(SortOrder.ASC))

Few samples here might help you.

edited Nov 29 '16 at 12:50

Eddie Curtis

1,207
8
20

answered Nov 29 '16 at 10:38

Kulasangar

9,046
5
51
82

Sortorder in Elasticsearch

1 Answers1