# Function Score Functions with Nested Objects and Score Replace **URL:** \ **Category:** Elasticsearch\ **Tags:** painless, eql-elastic-query-language\ **Created:** [April 24, 2022, 2:59am UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081 "2022-04-24T02:59:58Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![terzano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/terzano/32/104654_2.png) [@terzano](https://discuss.elastic.co/u/terzano)\ **Post date:** [April 24, 2022, 2:59am UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081/1 "2022-04-24T02:59:58Z")
I have tried various approaches to combine function\_score with a nested field inside "functions" in order to override the relevance \_score. The "query" within the function\_score works perfectly, as intended. However, the score always defaults to 1 as shown within the "\_explanation" object (see below). I simplified the query removing all aggregations and most filters to exemplify the issue: Query: ```auto { "_source": true, "from": 0, "size": 60, "query": { "function_score": { "boost_mode": "replace", "query": { "bool": { "filter": [ { "terms": { "brand_product": [ "false" ] } }, { "nested": { "path": "color_data", "query": { "function_score": { "boost_mode": "sum", "score_mode": "multiply", "functions": [ { "linear": { "color_data.density": { "offset": 5, "origin": 100, "scale": 10 } } }, { "exp": { "color_data.hsl.h": { "offset": 2, "origin": 226, "scale": 4 } } }, { "exp": { "color_data.hsl.s": { "offset": 4, "origin": 62, "scale": 8 } } }, { "exp": { "color_data.hsl.l": { "offset": 4, "origin": 41, "scale": 8 } } } ], "query": { "bool": { "must": [ { "range": { "color_data.density": { "gte": 40, "lte": 100 } } }, { "range": { "color_data.hsl.h": { "gte": 200, "lte": 254 } } }, { "range": { "color_data.hsl.s": { "gte": 41, "lte": 84 } } }, { "range": { "color_data.hsl.l": { "gte": 24, "lte": 58 } } } ] } } } } } } ], "must": [ { "match_all": {} } ] } }, "score_mode": "sum", "functions": [ { "script_score": { "script": "_score" } } ] } } } ``` This is what I get on the explanation object: ```auto { "_explanation": { "value": 1, "description": "sum of:", "details": [ { "value": 1, "description": "min of:", "details": [ { "value": 1, "description": "script score function, computed with script:\"Script{type=inline, lang='painless', idOrCode='_score', options={}, params={}}\"", "details": [ { "value": 1, "description": "_score: ", "details": [ { "value": 1, "description": "ConstantScore(#ConstantScore(brand_product:F) #ToParentBlockJoinQuery (+function score (+color_data.density:[40 TO 100] +color_data.hsl.h:[200 TO 254] +color_data.hsl.s:[41 TO 84] +color_data.hsl.l:[24 TO 58], functions: [{org.elasticsearch.index.query.functionscore.DecayFunctionBuilder$NumericFieldDataScoreFunction@2acaad3f}{org.elasticsearch.index.query.functionscore.DecayFunctionBuilder$NumericFieldDataScoreFunction@547c3b41}{org.elasticsearch.index.query.functionscore.DecayFunctionBuilder$NumericFieldDataScoreFunction@127c3b4c}{org.elasticsearch.index.query.functionscore.DecayFunctionBuilder$NumericFieldDataScoreFunction@127c3b45}]) #_nested_path:color_data))", "details": [] } ] } ] }, { "value": 3.4028235e+38, "description": "maxBoost", "details": [] } ] }, { "value": 0, "description": "match on required clause, product of:", "details": [ { "value": 0, "description": "# clause", "details": [] }, { "value": 1, "description": "DocValuesFieldExistsQuery [field=_primary_term]", "details": [] } ] } ] } } ``` All of the hits end up w/ a "score": 1 as if the nested field wasn't found. The Query with the combination of function\_score, bool and nested field works perfectly and returns results meeting all the filters and **color\_data** range requirements. Any help is greatly appreciated! ---
**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\ **Post date:** [April 25, 2022, 5:56pm UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081/2 "2022-04-25T17:56:36Z")
> [@terzano](#): > > ```auto > "function_score": { > "boost_mode": "replace", > > ``` you want replace? Only function score is used, the query score is ignored. ---
**Author:** ![terzano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/terzano/32/104654_2.png) [@terzano](https://discuss.elastic.co/u/terzano)\ **Post date:** [April 25, 2022, 9:04pm UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081/3 "2022-04-25T21:04:09Z")
I may combine it later for a more balanced scoring, either via sum or multiply. However, at this moment I do want "`replace`" to see the full effects of the Decay Functions. I am not interested in the Query Score yet. ---
**Author:** ![terzano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/terzano/32/104654_2.png) [@terzano](https://discuss.elastic.co/u/terzano)\ **Post date:** [April 28, 2022, 4:25pm UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081/4 "2022-04-28T16:25:31Z")
Hi @RabBit_BR , do you have any advise based on the reply? Thank you very much. ---
**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\ **Post date:** [April 28, 2022, 5:00pm UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081/5 "2022-04-28T17:00:44Z")
Hi. I'm not sure how your query should work but I would remove the "nested" from the "filter" clause because filter does not impact the score calculation. Maybe this: ```auto { "_source": true, "from": 0, "size": 60, "query": { "function_score": { "boost_mode": "replace", "query": { "bool": { "filter": [ { "terms": { "brand_product": [ "false" ] } } ], "must": [ { "nested": { "path": "color_data", "query": { "function_score": { "boost_mode": "sum", "score_mode": "multiply", "functions": [ { "linear": { "color_data.density": { "offset": 5, "origin": 100, "scale": 10 } } }, { "exp": { "color_data.hsl.h": { "offset": 2, "origin": 226, "scale": 4 } } }, { "exp": { "color_data.hsl.s": { "offset": 4, "origin": 62, "scale": 8 } } }, { "exp": { "color_data.hsl.l": { "offset": 4, "origin": 41, "scale": 8 } } } ], "query": { "bool": { "must": [ { "range": { "color_data.density": { "gte": 40, "lte": 100 } } }, { "range": { "color_data.hsl.h": { "gte": 200, "lte": 254 } } }, { "range": { "color_data.hsl.s": { "gte": 41, "lte": 84 } } }, { "range": { "color_data.hsl.l": { "gte": 24, "lte": 58 } } } ] } } } } } }, { "match_all": {} } ] } }, "score_mode": "sum", "functions": [ { "script_score": { "script": "_score" } } ] } } } ``` ---
**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\ **Post date:** [April 29, 2022, 1:49pm UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081/6 "2022-04-29T13:49:35Z")
Hi @terzano, did you find the solution? ---
**Author:** ![terzano](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/terzano/32/104654_2.png) [@terzano](https://discuss.elastic.co/u/terzano)\ **Post date:** [May 3, 2022, 5:31am UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081/7 "2022-05-03T05:31:01Z")
That is it, thanks @RabBit_BR !! Filters do not affect score calculations and consequently it needs to be removed from it. I thought it would since it was wrapped in a function\_score but it obviously does not. I think I have enough to proceed and solve the problem. Thanks a million! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 31, 2022, 5:31am UTC](https://discuss.elastic.co/t/function-score-functions-with-nested-objects-and-score-replace/303081/8 "2022-05-31T05:31:48Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.