# Returning multiple values on aggregation

**URL:** <https://discuss.elastic.co/t/returning-multiple-values-on-aggregation/21617>\
**Category:** Elasticsearch\
**Created:** [January 13, 2015, 10:24pm UTC](https://discuss.elastic.co/t/returning-multiple-values-on-aggregation/21617 "2015-01-13T22:24:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![makkalot](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/makkalot/32/992_2.png) [@makkalot](https://discuss.elastic.co/u/makkalot)\
**Post date:** [January 13, 2015, 10:24pm UTC](https://discuss.elastic.co/t/returning-multiple-values-on-aggregation/21617/1 "2015-01-13T22:24:18Z")

</div>

Hi,

I have an bulk aggregation and want to display a few of the fields not only  
the key i'm splitting. The query is something like this :

{  
"size": 0,  
"fields" : ["title"],  
"aggs": {  
"group\_by\_authors": {  
"terms": {  
"script": "doc['author'].value"  
},  
"aggs":{  
"get\_by\_local\_id":{  
"terms":{  
"field":"local\_id"  
}  
}  
}  
}  
}  
}

With the query above i'm able to split the docs according to the authors  
and then on sub-aggregation i pull the document ids those people are  
related to.  
What i need is instead of getting only the ids (local\_id) to get more  
fields of document. I can use terms + script but again i have one value  
back. Which is  
something like :

{  
"size": 0,  
"fields" : ["title"],  
"aggs": {  
"group\_by\_authors": {  
"terms": {  
"script": "doc['authors.name'].value + '|' +  
doc['authors.email'].value"  
},  
"aggs":{  
"get\_by\_local\_id":{  
"terms":{  
"field":"local\_id",  
"script":"doc['type'].value"  
}  
}  
}  
}  
}  
}

I can do some magic with script to get more values and then parse it in my  
code but, it becomes very ugly. On docs it says it is possible to get  
multiple  
values back on aggregation. Any examples would be very useful.

Thanks in advance.

--  
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/06d8e351-52af-4f1d-a1d2-80f789327315%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/06d8e351-52af-4f1d-a1d2-80f789327315%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![colings86](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/colings86/32/44960_2.png) [@colings86](https://discuss.elastic.co/u/colings86)\
**Post date:** [January 14, 2015, 1:07pm UTC](https://discuss.elastic.co/t/returning-multiple-values-on-aggregation/21617/2 "2015-01-14T13:07:40Z")

</div>

Would the top\_hits aggregation help you here? It allows you to display the  
top N documents which fall into a particular bucket in the aggregations.

> **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)**
>
> Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today.

Colin

On Tuesday, 13 January 2015 22:24:18 UTC, makkalot wrote:

> Hi,
> 
> I have an bulk aggregation and want to display a few of the fields not  
> only the key i'm splitting. The query is something like this :
> 
> {  
> "size": 0,  
> "fields" : ["title"],  
> "aggs": {  
> "group\_by\_authors": {  
> "terms": {  
> "script": "doc['author'].value"  
> },  
> "aggs":{  
> "get\_by\_local\_id":{  
> "terms":{  
> "field":"local\_id"  
> }  
> }  
> }  
> }  
> }  
> }
> 
> With the query above i'm able to split the docs according to the authors  
> and then on sub-aggregation i pull the document ids those people are  
> related to.  
> What i need is instead of getting only the ids (local\_id) to get more  
> fields of document. I can use terms + script but again i have one value  
> back. Which is  
> something like :
> 
> {  
> "size": 0,  
> "fields" : ["title"],  
> "aggs": {  
> "group\_by\_authors": {  
> "terms": {  
> "script": "doc['authors.name'].value + '|' +  
> doc['authors.email'].value"  
> },  
> "aggs":{  
> "get\_by\_local\_id":{  
> "terms":{  
> "field":"local\_id",  
> "script":"doc['type'].value"  
> }  
> }  
> }  
> }  
> }  
> }
> 
> I can do some magic with script to get more values and then parse it in my  
> code but, it becomes very ugly. On docs it says it is possible to get  
> multiple  
> values back on aggregation. Any examples would be very useful.
> 
> Thanks in advance.

--  
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/ea280fc8-ad63-41e2-bf8a-d1668eec9640%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/ea280fc8-ad63-41e2-bf8a-d1668eec9640%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, 12:39am UTC](https://discuss.elastic.co/t/returning-multiple-values-on-aggregation/21617/3 "2017-07-06T00:39:01Z")

</div>