# Cannot access doc\['field'\].value in ElasticSearch aggregation script

**URL:** <https://discuss.elastic.co/t/cannot-access-doc-field-value-in-elasticsearch-aggregation-script/17694>\
**Category:** Elasticsearch\
**Created:** [May 23, 2014, 12:49pm UTC](https://discuss.elastic.co/t/cannot-access-doc-field-value-in-elasticsearch-aggregation-script/17694 "2014-05-23T12:49:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Benjamin\_Smith](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/benjamin_smith/32/1513_2.png) [@Benjamin\_Smith](https://discuss.elastic.co/u/Benjamin_Smith)\
**Post date:** [May 23, 2014, 12:49pm UTC](https://discuss.elastic.co/t/cannot-access-doc-field-value-in-elasticsearch-aggregation-script/17694/1 "2014-05-23T12:49:01Z")

</div>

Anyone have some insight re: the following aggregation? I cannot access any  
properties of the document in my script.

With the following query:

{  
"query": {  
"filtered": {  
"filter": [],  
"query": {  
"bool": {  
"must": [  
{  
"query\_string": {  
"fields": [  
"title"  
],  
"query": "test"  
}  
}  
]  
}  
}  
}  
},  
"aggs": {  
"my\_field": {  
"terms": {  
"field": "my\_field.name.raw",  
"script": "doc['title'].value"  
}  
}  
}  
}

I get the following error:

QueryPhaseExecutionException[[index\_name][2]:  
query[title:test],from[0],size[10]: Query Failed [Failed to execute main  
query]]; nested: PropertyAccessException[[Error: doc['title'].value: null]  
[Near : {... doc['title'].value ....}] ^ [Line: 1, Column: 1]]; nested:  
InvocationTargetException; nested: ArrayIndexOutOfBoundsException;

I also try using \_source.title, doc.get('title').value, and other  
combinations of the doc['field'] syntax - none are working for me. Is there  
a special nuance for using script within an aggregation? Am I missing  
something obvious?

This fails on both ES 1.1.1 and 1.2.0.

_(also posted on StackOverflow  
 [http://stackoverflow.com/questions/23815993/cannot-access-docfield-value-in-elasticsearch-aggregation-script](http://stackoverflow.com/questions/23815993/cannot-access-docfield-value-in-elasticsearch-aggregation-script))_

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/695eccfd-d91c-4215-bc7d-19d3b836b6ce%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/695eccfd-d91c-4215-bc7d-19d3b836b6ce%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:27am UTC](https://discuss.elastic.co/t/cannot-access-doc-field-value-in-elasticsearch-aggregation-script/17694/2 "2017-07-06T01:27:24Z")

</div>