# Problem creating query

**URL:** <https://discuss.elastic.co/t/problem-creating-query/96634>\
**Category:** Elasticsearch\
**Created:** [August 10, 2017, 3:10pm UTC](https://discuss.elastic.co/t/problem-creating-query/96634 "2017-08-10T15:10:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jhon\_David\_Castillo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jhon_david_castillo/32/21016_2.png) [@Jhon\_David\_Castillo](https://discuss.elastic.co/u/Jhon_David_Castillo)\
**Post date:** [August 10, 2017, 3:10pm UTC](https://discuss.elastic.co/t/problem-creating-query/96634/1 "2017-08-10T15:10:30Z")

</div>

I need to create a query that throws the following:

{  
"occurrences": [  
{  
"providerName": "",  
"resourceCount": 123,  
"registryCount": 123  
}  
]  
}

It would be a kind of groupby by ProviderName

I have done the following

client.search({  
index: 'sibdataportal',  
type: 'occurrence',  
body: {  
"query":{  
"term" : {  
"[provider.id](http://provider.id)" : 4  
}  
},

```
"_source": ["provider.id"],
"aggs":{
"group_by_provider": {
  "terms": {
    "field": "provider.id"
  }
}
}

}

```

}  
**Structure**

"\_index" : "sibdataportal",  
"\_type" : "occurrence",  
"\_id" : "5968dd8a951e3877ac39f5a2",  
"\_score" : 1.0,  
"\_source" : {  
"basis\_of\_record" : {  
"name" : "HumanObservation"  
},  
"canonical" : "Carollia perspicillata",  
"catalog" : {  
"number" : "2009.0122"  
},  
"collection" : {  
"code" : "Asociacion de Becarios de Casanare"  
},  
"continent\_interpreted" : "América",  
"country\_capital\_interpreted" : "Bogotá",  
"country\_iso\_code\_interpreted" : "CO",  
"country\_name" : "Colombia",  
"country\_name\_english\_interpreted" : "Colombia",  
"country\_name\_spanish\_interpreted" : "Colombia",  
"country\_name\_verbatim" : "Colombia",  
"day\_start" : 24,  
"department\_interpreted" : "Casanare",  
"department\_name" : "Casanare",  
"department\_name\_verbatim" : "Casanare",  
"dwca\_id" : "ABC-MURCIELAGOS-2009-0122",  
"eventdate\_start" : "2009-01-24T00:00:00-05:00",  
"habitat" : "Bosque de tierra firme",  
"id" : 6492152,  
"institution" : {  
"code" : "ABC"  
},  
"locality" : "Laguna el Tinije",  
"location" : {  
"lat" : 4.89430555555556,  
"lon" : -72.4023888888889  
},  
"month\_start" : 1,  
"occurrenceid" : "ABC-MURCIELAGOS-2009-0122",  
"provider" : {  
"address" : "Calle 17 No. 15 - 55",  
"city" : "Yopal",  
"description" : "La Asociación de Becarios de Casanare esta conformada por becarios del fondo educativo de la BP para Casanare. El nodo cuenta con información de aves, peces, anfibios, reptiles, plantas, insectos y murcielafgos en el marco del proyecto “Establecimiento de la Composición Biológica y Estructura Ecológica de la Laguna El Tinije, Casanare, Colombia",  
"email" : "contacto@abccolombia.org",  
"id" : 3,  
"name" : "Asociación de Becarios del Casanare - ABC",  
"phone" : "57 (8) 6358938",  
"website\_url" : "http://asociacionbecarioscasanare.org/"  
},  
"resource" : {  
"alternate\_identifier" : "doi:10.15472/ch49b6",  
"citation" : "Asociación Becarios de Casanare - ABC (2009). Mamíferos voladores laguna El Tinije, 593 registros, aportados por Ramírez, B.( Publicador, Creador del Recurso, Proveedor de los Metadatos), Rodríguez, M. (Autor), En línea, http://ipt.sibcolombia.net/sib/manage/resource.do?r=abc-2009-murcielagos, publicado el 04/12/2012.",  
"description" : "La tabla contiene 593 registros de murciélagos en la Laguna El Tinije. Mediante el estudio de la comunidad de murciélagos, se evaluó el estado de conservación de la localidad. La captura de murciélagos se realizó utilizando redes de niebla de 50/2 denier, 38 mm (Avinet) ubicadas en el sotobosque.Las redes se mantuvieron abiertas entre las 18:00h y 06:00h aproximadamente.",  
"gbif\_package\_id" : "acdf883a-82fc-4181-bbdc-6f47d46e8b6c",  
"hierarchy\_level" : "dataset",  
"id" : 38,  
"intellectual\_rights" : "To the extent possible under law, the publisher has waived all rights to these data and has dedicated them to the \<a href="http://creativecommons.org/publicdomain/zero/1.0/legalcode"\>Public Domain (CC0 1.0). Users may copy, modify, distribute and use the work, including for commercial purposes, without restriction.",  
"keyword" : "Murciélagos, mamíferos, laguna El Tinije.",  
"keyword\_thesaurus" : "n/a",  
"language" : "spa",  
"logo\_url" : "[https://s3.amazonaws.com/IPT/img/logos/abc.png](https://s3.amazonaws.com/IPT/img/logos/abc.png)",  
"name" : "Mamíferos voladores laguna El Tinije",  
"publication\_date" : "2017-02-17T00:00:00-05:00",  
"title" : "Mamíferos voladores laguna El Tinije"  
},  
"sourcefileid" : "abc-2009-murcielagos",  
"taxon\_rank" : "Especie",  
"taxonomy" : {  
"class\_name" : "Mammalia",  
"family\_name" : "Phyllostomidae",  
"genus\_name" : "Carollia",  
"kingdom\_name" : "Animalia",  
"order\_name" : "Chiroptera",  
"phylum\_name" : "Chordata",  
"species\_name" : "Carollia perspicillata",  
"specific\_epithet" : "perspicillata"  
},  
"year\_start" : 2009  
}  
}

---

<div class="post-metadata">

**Author:** ![talevy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/talevy/32/44896_2.png) [@talevy](https://discuss.elastic.co/u/talevy)\
**Post date:** [August 10, 2017, 5:37pm UTC](https://discuss.elastic.co/t/problem-creating-query/96634/2 "2017-08-10T17:37:30Z")

</div>

Hi,

I'm a little confused if you are looking to do something beyond the regular  
terms aggregation, or whether the terms aggregation is not working as you expect.

How do `registryCount` and `resourceCount` relate to the fields of your documents?

---

<div class="post-metadata">

**Author:** ![Jhon\_David\_Castillo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jhon_david_castillo/32/21016_2.png) [@Jhon\_David\_Castillo](https://discuss.elastic.co/u/Jhon_David_Castillo)\
**Post date:** [August 10, 2017, 5:57pm UTC](https://discuss.elastic.co/t/problem-creating-query/96634/3 "2017-08-10T17:57:04Z")

</div>

I am interested in extracting the resourcesCount with an aggregations but as I have it does not work, porq does not do the groupby by ProviderName

---

<div class="post-metadata">

**Author:** ![talevy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/talevy/32/44896_2.png) [@talevy](https://discuss.elastic.co/u/talevy)\
**Post date:** [August 14, 2017, 9:12pm UTC](https://discuss.elastic.co/t/problem-creating-query/96634/4 "2017-08-14T21:12:50Z")

</div>

mind sharing your full query? I do not see a reason why  
you cannot bucket by the `id` field

---

<div class="post-metadata">

**Author:** ![Jhon\_David\_Castillo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jhon_david_castillo/32/21016_2.png) [@Jhon\_David\_Castillo](https://discuss.elastic.co/u/Jhon_David_Castillo)\
**Post date:** [August 22, 2017, 10:12pm UTC](https://discuss.elastic.co/t/problem-creating-query/96634/5 "2017-08-22T22:12:42Z")

</div>

> [@talevy](#):
>
> mind sharing your full query? I do not see a reason why
> 
> you cannot bucket by the id field

I need to group by Provider.Name to be able to count how many Resource Documents exist per provider.

Which generates an error generally which is fixed with Fielddata = true, but regenerates the mapping and inserts the data again and returns the error

---

<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:** [September 19, 2017, 10:12pm UTC](https://discuss.elastic.co/t/problem-creating-query/96634/6 "2017-09-19T22:12:54Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.