Are there some mechanism how we can sort the fields in the query?
Same as below.
{
field1 => ""
field2 => ""
field3 => ""
}
In sql command, it is equivalent to "Order by field1,field2,field3"
you can sort on several fields, where each field is used as a tie breaker in case the previously listed field has the same values when two documents are compared. See https://www.elastic.co/guide/en/elasticsearch/reference/7.4/search-request-body.html#request-body-search-sort
looks like it is sort by values, not sort by fieldnames. Can you give me an example on how to do that?