# Selecting documents in elasticsearch

**URL:** <https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652>\
**Category:** Elasticsearch\
**Created:** [February 10, 2017, 12:58pm UTC](https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652 "2017-02-10T12:58:43Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![daaakeee](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@daaakeee](https://discuss.elastic.co/u/daaakeee)\
**Post date:** [February 10, 2017, 12:58pm UTC](https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652/1 "2017-02-10T12:58:43Z")

</div>

I am trying to select documents that contain another document in  
elasticsearch grouped by id field.. I think it is more understable by  
the next example:

```auto
"doc1": {
   "id": "firstid"
   "my_field":"1"
}
"doc2": {
   "id": "firstid"
   "my_field":"12"
}
"doc3": {
   "id": "firstid"
   "my_field":"123"
}
"doc4": {
   "id": "secondid"
   "my_field":"1234"
}
"doc5": {
   "id": "firstid"
   "my_field":"12"
}
"doc6": {
   "id": "firstid"
   "my_field":"1"
}
"doc7": {
    "id":"firstid"
    "my_field":"qwerty" 
 }
 "doc8" {
     "id": "firstid"
     "my_field": "qwer"
  }

```

I want output to be

```auto
"doc3":{
   "id": "firstid"
   "my_field":"123"
 }
 "doc4": {
   "id": "secondid"
   "my_field":"1234"
}
"doc7": {
    "id":"firstid"
    "my_field":"qwerty" 
 }

```

Thank you in advance!

---

<div class="post-metadata">

**Author:** ![nik9000](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nik9000/32/44947_2.png) [@nik9000](https://discuss.elastic.co/u/nik9000)\
**Post date:** [February 10, 2017, 4:05pm UTC](https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652/2 "2017-02-10T16:05:06Z")

</div>

First: use ``` around code blocks so they are more readable. I've used my magic admin powers to add them in for you.

Second: I can't figure out what you are trying to do from your example.

---

<div class="post-metadata">

**Author:** ![daaakeee](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@daaakeee](https://discuss.elastic.co/u/daaakeee)\
**Post date:** [February 10, 2017, 5:54pm UTC](https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652/3 "2017-02-10T17:54:56Z")

</div>

@nik9000 sorry, I am new in using this wonderful service.. I am asking for a help from discuss audience to write a query that will output me unique documents that follow next rules:

1. Documents grouped by the id's
2. Then grouped documents should be grouped by the content of field "my\_field"  
So, from the example we get "doc3", which has "id":"firstid" and its field "my\_field" contains doc1["my\_field"] and doc2["my\_field"] content..

Hope, I have explained enough:D

---

<div class="post-metadata">

**Author:** ![nik9000](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nik9000/32/44947_2.png) [@nik9000](https://discuss.elastic.co/u/nik9000)\
**Post date:** [February 10, 2017, 6:28pm UTC](https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652/4 "2017-02-10T18:28:19Z")

</div>

You might be looking for the `terms` aggregation, not a query at all.

---

<div class="post-metadata">

**Author:** ![daaakeee](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@daaakeee](https://discuss.elastic.co/u/daaakeee)\
**Post date:** [February 10, 2017, 6:42pm UTC](https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652/5 "2017-02-10T18:42:02Z")

</div>

Thank you very much, I will look for it. @nik9000

---

<div class="post-metadata">

**Author:** ![daaakeee](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@daaakeee](https://discuss.elastic.co/u/daaakeee)\
**Post date:** [February 11, 2017, 6:46am UTC](https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652/6 "2017-02-11T06:46:47Z")

</div>

@nik9000 Hi:D can you send query please?

---

<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:** [March 11, 2017, 6:47am UTC](https://discuss.elastic.co/t/selecting-documents-in-elasticsearch/74652/7 "2017-03-11T06:47:50Z")

</div>

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