Can we Round off the score in Elasticsearch

Question

I am implementing a project in which the results are to be sorted based on score and in case of same score the result set to be sorted based on date field. The issue arises when the score differs by .00001 i.e by 5th or 6th Decimal position. Is there any way by which we can round off the score derived in Elasticsearch to 4th place of decimal so that the secondary sort can work on it. if not any workaround by which this can be achieved.

Thanks Ashit

Answer 1

Here is a working solution using script score to round the actual score

GET /post/_search
{
    "query": {
        "function_score": {
            "query": {
                "match": {"title": "example"}
            },
            "script_score" : {
                "script" : {
                  "source": "Math.round(_score)"
                }
            }
        }
    },
    "sort": [
        "_score",
        {"postdate": "desc"}
    ]
}

In this search example we first sort on the rounded _score then on post.postdate in descending order.