# How to query array of keywords in elastic search filter with space?

**URL:** <https://discuss.elastic.co/t/how-to-query-array-of-keywords-in-elastic-search-filter-with-space/196894>\
**Category:** Elasticsearch\
**Created:** [August 27, 2019, 7:33am UTC](https://discuss.elastic.co/t/how-to-query-array-of-keywords-in-elastic-search-filter-with-space/196894 "2019-08-27T07:33:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kavaan](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@kavaan](https://discuss.elastic.co/u/kavaan)\
**Post date:** [August 27, 2019, 7:33am UTC](https://discuss.elastic.co/t/how-to-query-array-of-keywords-in-elastic-search-filter-with-space/196894/1 "2019-08-27T07:33:24Z")

</div>

I have a list of cities like this:

`["New York","Bayern Munchen","Porto Alegre"]`

I want to search some query in must or should section and use this cities keywords in filter section, but this cities have white space and elastic search does not response.

```
{  
   "query":{  
      "bool":{  
         "should":[  
            {  
               "match_phrase":{  
                  "title":"pizza"
               }
            },
            {  
               "match_phrase":{  
                  "content":"foods"
               }
            }
         ],
         "filter":[  
            {  
               "range":{  
                  "date":{  
                     "gte":"2015-01-01"
                  }
               }
            },
            {  
               "terms":{  
                  "cities":[  
                     "New York",
                     "Bayern Munchen",
                     "Porto Alegre"
                  ]
               }
            }
         ],
         "minimum_should_match":1
      }
   }
}

```

this code use "terms" in filter, but the result is empty. How can i use this keywords in filter section?

---

<div class="post-metadata">

**Author:** ![wangqinghuan](https://avatars.discourse-cdn.com/v4/letter/w/d26b3c/32.png) [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Post date:** [August 27, 2019, 7:53am UTC](https://discuss.elastic.co/t/how-to-query-array-of-keywords-in-elastic-search-filter-with-space/196894/2 "2019-08-27T07:53:07Z")

</div>

I believe you should use "cities.keyword".

```
{  
               "terms":{  
                  "cities.keyword":[  
                     "New York",
                     "Bayern Munchen",
                     "Porto Alegre"
                  ]
               }
            }
```

---

<div class="post-metadata">

**Author:** ![kavaan](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@kavaan](https://discuss.elastic.co/u/kavaan)\
**Post date:** [August 27, 2019, 8:15am UTC](https://discuss.elastic.co/t/how-to-query-array-of-keywords-in-elastic-search-filter-with-space/196894/3 "2019-08-27T08:15:33Z")

</div>

thank you very much.😀🙏

---

<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 24, 2019, 8:15am UTC](https://discuss.elastic.co/t/how-to-query-array-of-keywords-in-elastic-search-filter-with-space/196894/4 "2019-09-24T08:15:34Z")

</div>

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