ElasticSearch - sort search results by relevance and custom field (Date)

Question

For example, I have entities with two fields - Text and Date. I want search by entities with results sorted by Date. But if I do it simply, then the result is unexpected.
For search query "Iphone 6" there are the newest texts only with "6" in top of еру results, not with "iphone 6". Without sorting the results seem nice, but not ordered by Date as I want.
How write custom sort function which will consider both relevance and Date? Or may be exist way to give weight to field Date which will be consider in scoring?

In addition, may be I shall want to suppress search results only with "6". How to customize search to find results only by bigrams for example?

Answer 1

The solution is to use _score and the date field both in sort. _score as the first sort order and date field as secondary sort order.

You can use simple match query to perform relevance match.

Try it out.

Data setup:

POST ecom/prod
{
    "name":"iphone 6",
    "date":"2019-02-10"
}

POST ecom/prod
{
    "name":"iphone 5",
    "date":"2019-01-10"
}

POST ecom/prod
{
    "name":"iphone 6",
    "date":"2019-02-28"
}

POST ecom/prod
{
    "name":"6",
    "date":"2019-03-01"
}

Query for relevance and date based sorting:

POST ecommerce/prododuct/_search
{
    "query": {
        "match": {
           "name": "iphone 6"
        }
    },
    "sort": [
       {
          "_score": {
             "order": "desc"
          }
       },
       {
           "date": {
             "order": "desc"
          }
       }
    ]
}

Answer 2

Did you tried with bool query like this

{
  "query": {
    "bool": {
      "must": {
        "match": {
          "field": "iphone 6"
        }
      }
    }
  },
  "sort": {
    "date": {
      "order": "desc"
    }
  }
}

or with your query you can also do this with is more appropriate way of doing i guess ..

just add this as sort

"sort": [
        { "date":   { "order": "desc" }},
        { "_score": { "order": "desc" }}
    ]

all matching results sorted first by date, then by relevance.