this only sort on a field string. I would like to sort on two fields, the first is _score and then a string field, e.g. cityname.
searchRequestBuilder.setTrackScores(true); searchRequestBuilder.addSort(SortBuilders.fieldSort("_score").order(SortOrder.DESC)); searchRequestBuilder.addSort(SortBuilders.fieldSort("cityname").order(SortOrder.DESC).missing("_last");
the sorted result on _score is perfect, however, on the cityname, there are some empty field such as the one below.
kuala lumpur 80 75 new york 65
any idea how to make it to
kuala lumpur 80 new york 65 75