# Question: How to write query elastic search?

**URL:** https://discuss.elastic.co/t/question-how-to-write-query-elastic-search/138499
**Category:** Elasticsearch
**Created:** [July 4, 2018, 7:29am UTC](https://discuss.elastic.co/t/question-how-to-write-query-elastic-search/138499 "2018-07-04T07:29:17Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![minhthuan274](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/minhthuan274/32/32940_2.png) [@minhthuan274](https://discuss.elastic.co/u/minhthuan274)
#### Post date: [July 4, 2018, 7:29am UTC](https://discuss.elastic.co/t/question-how-to-write-query-elastic-search/138499/1 "2018-07-04T07:29:17Z")

</div>

I have a index review like this

```auto
{
        "_index": "zody_review",
        "_type": "review",
        "_id": "5b3c6c9e68cf860e1af5f7fd",
        "_score": null,
        "_source": {
          "user": "571899623dc63af34d67a662",
          "merchant": "56f8f80119a4c1ae791cf7bf",
          "point": 3,
          "score": 2,
          "createdAt": "2018-07-04T13:43:42.331+07:00",
          "location": {
            "lat": 16.07054040054832,
            "lon": 108.22062939405441
          },
          "feedback": "Phuc vu khong tot lam "
        }
      },

```

How can I query to get list review nearby, but limit get 5 reviews for each group by field merchant ?  
I've been stuck here too long!  
Thank you!

---

<div class="post-metadata">

### Author: ![jaddison](https://avatars.discourse-cdn.com/v4/letter/j/e5b9ba/32.png) [@jaddison](https://discuss.elastic.co/u/jaddison)
#### Post date: [July 4, 2018, 5:10pm UTC](https://discuss.elastic.co/t/question-how-to-write-query-elastic-search/138499/2 "2018-07-04T17:10:06Z")

</div>

What's your elasticsearch version?

What is the mapping for the document you mention?

---

<div class="post-metadata">

### Author: ![minhthuan274](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/minhthuan274/32/32940_2.png) [@minhthuan274](https://discuss.elastic.co/u/minhthuan274)
#### Post date: [July 4, 2018, 10:44pm UTC](https://discuss.elastic.co/t/question-how-to-write-query-elastic-search/138499/3 "2018-07-04T22:44:20Z")

</div>

I'm using version 6.2  
And this mapping

```auto
"mappings": {
    "review": {
      "properties": {
        "merchant": {
          "type": "keyword"
        },
        "user": {
          "type": "keyword"
        },
        "point": {
          "type": "integer"
        },
        "createdAt": {
          "type": "date"
        },
        "score": {
          "type": "float"
        },
        "location": {
          "type": "geo_point"
        },
        "feedback": {
          "type": "text",
          "fields": {
            "search": {
              "type": "text",
              "analyzer": "edge_ngram"
            }
          }
        }
      }
    }
}

```

---

<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: [August 1, 2018, 10:44pm UTC](https://discuss.elastic.co/t/question-how-to-write-query-elastic-search/138499/4 "2018-08-01T22:44:24Z")

</div>

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