# How to retrieve a field value from inner\_hits filtered object **URL:** \ **Category:** Elasticsearch\ **Created:** [October 25, 2016, 12:50am UTC](https://discuss.elastic.co/t/how-to-retrieve-a-field-value-from-inner-hits-filtered-object/63813 "2016-10-25T00:50:50Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![pungent](https://avatars.discourse-cdn.com/v4/letter/p/a698b9/32.png) [@pungent](https://discuss.elastic.co/u/pungent)\ **Post date:** [October 25, 2016, 12:50am UTC](https://discuss.elastic.co/t/how-to-retrieve-a-field-value-from-inner-hits-filtered-object/63813/1 "2016-10-25T00:50:50Z")
In my mapping document, I have one of the nested object as follows ``` "availabilities":{ "type": "nested", "dynamic": "strict", "properties": { "start": { "type": "date", "format": "yyyy-MM-dd" }, "end": { "type": "date", "format": "yyyy-MM-dd" }, "age": { "type": "integer" } } } ``` I have a long DSL query, in which one of the filters is: ``` { "nested": { "path": "availabilities", "inner_hits" : { "size": 1, "name": "selected_availabilities" }, "query": { "bool": { "must": [ { "range": { "availabilities.start": { "gte": "2016-10-08", "lte": "2016-10-08" } } }, { "range": { "availabilities.end": { "gte": "2016-10-17", "lte": "2016-10-17" } } } ] } } } } ``` I am trying to use `inner_hits` to get the selected availabilities object and that returns something like this: ``` { "took": 5, "timed_out": false, "_shards": { "total": 5, "successful": 5, "failed": 0 }, "hits": { "total": 1, "max_score": 6000, "hits": [ { "_index": "listings_v1", "_type": "listing", "_id": "228527", "_score": 6000, "_source": { ...my fields.... ...my fields.... ...my fields.... ...my fields.... ...availabilities has nested objects..... }, "inner_hits": { "selected_availabilities": { "hits": { "total": 1, "max_score": 1.4142135, "hits": [ { "_type": "listing", "_id": "228527", "_nested": { "field": "availabilities", "offset": 3 }, "_score": 1.4142135, "_source": { "start": "2016-10-08", "end": "2016-10-17", "age": 23 } } ] } } } } ] } } ``` My goal is to use one of the fileds from the selected object in the inner\_hits for the calculation of the score. Since availabilities object may have multiple object, but there will ALWAYS be only one matching my search criteria. SO this is what I have as my query: ``` function_score": { "query": {}, "score_mode": "sum", "boost_mode": "replace" "functions": [ { "script_score": { "params": { "move_in_date_boost": -1350, "desired_move_in_date": "2016-11-03" }, "script": "return (inner_hits['selected_availabilities']['hits']['hits'][0]['_source']['age']);" } }, { ....more functions... } ] } ``` But when I use above script, I get the following error: ``` { "took": 239, "timed_out": false, "_shards": { "total": 5, "successful": 4, "failed": 1, "failures": [ { "shard": 0, "index": "xyz_v1", "node": "5645yDwf345we234236w", "reason": { "type": "script_exception", "reason": "failed to run inline script [return (inner_hits['selected_availabilities']['hits']['hits'][0]['_source']['age']);] using lang [groovy]", "caused_by": { "type": "missing_property_exception", "reason": "missing_property_exception: No such property: inner_hits for class: 572da4fc5f5e591a0d7cfec2cde0c998b550b1f4" } } } ] }, "hits": { "total": 0, "max_score": null, "hits": [] } } ``` How to get selected\_availabilities `age` field in score calculation? Any help will be highly appreciated. ---
**Author:** ![Bryan\_Warner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bryan_warner/32/1225_2.png) [@Bryan\_Warner](https://discuss.elastic.co/u/Bryan_Warner)\ **Post date:** [January 25, 2017, 5:09pm UTC](https://discuss.elastic.co/t/how-to-retrieve-a-field-value-from-inner-hits-filtered-object/63813/2 "2017-01-25T17:09:30Z")
Trying to do something similar and getting the same error - i.e. `missing_property_exception: No such property: inner_hits for class...` Are you not able to access `inner_hits` from scripts the same way you can access `_source`, `_score`, etc.? I see the field `inner_hits` present on the returned results from ES (just like above), and even put in extra _null_ checks to only access it in my script if it was present, but didn't make any difference Any feedback would be appreciated ---
**Author:** ![Elasticsircher](https://avatars.discourse-cdn.com/v4/letter/e/7ab992/32.png) [@Elasticsircher](https://discuss.elastic.co/u/Elasticsircher)\ **Post date:** [June 15, 2017, 9:34pm UTC](https://discuss.elastic.co/t/how-to-retrieve-a-field-value-from-inner-hits-filtered-object/63813/3 "2017-06-15T21:34:42Z")
I was struggling with this as well as I needed to boost my query score as a function of a field within inner hits. Per the following post, inner hits are not accessible within scripts: > [@Access to inner\_hits from painless script during sorting](https://discuss.elastic.co/t/access-to-inner-hits-from-painless-script-during-sorting/86926): > > I am using nested query in Elasticsearch search query. Something like this: "query": { "bool": { "must": [{ "bool": { "should": [{ "bool": { "should": [ { "match": { "id": { "query": "department1" } } }, { "match": { "id": { "query": "company1" } } }] } } ] } }, { "bool": { "should": [ { "bool": { "should": [ { "nested" : { "path" : "peoples", "ignore\_unmapped" : "true", "query" : { "bool" : { "must" : [ { "match" : { "peoples.firstName" : "firstNa… Bummer. However, I managed to find a solution to my problem by using a nested query with a function score query inside it computing the score contribution of the nested hit. For example, if you have the following mapping: ```auto { "properties": { "field": { "type": "nested", "properties": { "nested_field": { "type": "text" }, "nested_field_score": { "type": "float" } } } } } ``` Then you can do the following nested query: ```auto { "query": { "nested": { "path": "field", "query": { "function_score": { "query": { "match": { "field.nested_field": "" } } }, "script_score": { "script": "doc['field.nested_field_score'].value" } } } } } ``` You can then wrap this in a bool query and match non-nested fields along-side nested fields, each contributing a computed score. This doesn't solve all issues with not having access to inner hits but worked well in my case. ---
**Author:** ![spencerdemars](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spencerdemars/32/32327_2.png) [@spencerdemars](https://discuss.elastic.co/u/spencerdemars)\ **Post date:** [June 15, 2018, 5:10pm UTC](https://discuss.elastic.co/t/how-to-retrieve-a-field-value-from-inner-hits-filtered-object/63813/4 "2018-06-15T17:10:17Z")
Thanks this was a big help! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 4, 2022, 4:30am UTC](https://discuss.elastic.co/t/how-to-retrieve-a-field-value-from-inner-hits-filtered-object/63813/5 "2022-11-04T04:30:42Z")