how to add filters to elastic query when using function_score?

Question

Here is my current elastic query:

{
    "from": 0,
    "size": 10,
    "query": {
        "function_score": {
            "query": {
                "bool": {
                    "must": [{
                        "multi_match": {
                            "query": "ocean",
                            "fields": [],
                            "fuzziness": "AUTO"
                        }}],
                    "must_not": [{
                        "exists": {
                            "field": "parentId"
                        }
                    }]
                }
            },
            "functions" : [
                {
                    "gauss": {
                            "createTime": {
                                    "origin": "2020-07-09T23:50:00",
                                    "scale": "365d",
                                    "decay": 0.3
                            }
                    }
                }
            ]
        }
    }
}

How do I properly add filters to this? I think maybe the fact that I'm using function_score makes this different? I would like to add a hard filter, for example, only show me results with uploadUser: 'Mr. Bean' ... but still keep the scoring in place for the results that pass this filter.

I tried using filter in various places, also using must but I either get no results or all the results.

I'm using Elastic Search 7. Thanks for your help

can u share your sample data and result which u expect to get ? — Bhavya
– Bhavya, Commented Jul 15, 2020 at 16:54

Bhavya · Accepted Answer · 2020-07-15 17:09:41Z

2

You can try this below search query:

Refer this ES official documentation to know more about Function score query

    {
  "from": 0,
  "size": 10,
  "query": {
    "function_score": {
      "query": {
        "bool": {
          "filter": {
            "term": {
              "uploadUser": "Mr. Bean"
            }
          },
          "must": [
            {
              "multi_match": {
                "query": "ocean",
                "fields": [
                  
                ],
                "fuzziness": "AUTO"
              }
            }
          ],
          "must_not": [
            {
              "exists": {
                "field": "parentId"
              }
            }
          ]
        }
      },
      "functions": [
        {
          "gauss": {
            "createTime": {
              "origin": "2020-07-09T23:50:00",
              "scale": "365d",
              "decay": 0.3
            }
          }
        }
      ]
    }
  }
}

edited Jul 15, 2020 at 17:09

answered Jul 15, 2020 at 17:04

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Bhavya Over a year ago

@tyler-g can you try the above search query, and let me know if this works ? And, it would be great if you can provide some sample index data also and your expected result

darnitdiy Over a year ago

I tried that way and get no results unfortunately. Without the "filter" I get several results, and I can see some of them have uploadUser: Mr. Bean however as soon as I put the filter on I get no results

Bhavya Over a year ago

@tyler-g can u please share your index data and mapping, and even what search result you expect to get based on that index data ?

Bhavya Over a year ago

@tyler-g did you get a chance to go through my answer, looking forward to get feedback from you :)

darnitdiy Over a year ago

Yes got it working thanks for your feedback @Bhavya !

|

Collectives™ on Stack Overflow

how to add filters to elastic query when using function_score?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related