# Adding multiple filters at once

**URL:** https://discuss.elastic.co/t/adding-multiple-filters-at-once/134435
**Category:** Kibana
**Created:** [June 4, 2018, 2:13pm UTC](https://discuss.elastic.co/t/adding-multiple-filters-at-once/134435 "2018-06-04T14:13:33Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![I\_like\_dogs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/i_like_dogs/32/24384_2.png) [@I\_like\_dogs](https://discuss.elastic.co/u/I_like_dogs)
#### Post date: [June 4, 2018, 2:13pm UTC](https://discuss.elastic.co/t/adding-multiple-filters-at-once/134435/1 "2018-06-04T14:13:33Z")

</div>

hello,

I'm wanting to filter out Alexa top 500 DNS queries for a word cloud. For example:

{  
"query": {  
"bool": {  
"should": [  
{  
"match\_phrase": {  
"dns\_query.keyword": "[google.com](http://google.com)"  
}  
},  
{  
"match\_phrase": {  
"dns\_query.keyword": "[google.com](http://google.com)"  
}  
},  
{  
"match\_phrase": {  
"dns\_query.keyword": "[googleads.g.doubleclick.net](http://googleads.g.doubleclick.net)"  
}  
}  
],  
"minimum\_should\_match": 1  
}  
}  
}

However I have 500 URL's to filter. Is there a way to add all URL's to filter?

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [June 5, 2018, 6:43pm UTC](https://discuss.elastic.co/t/adding-multiple-filters-at-once/134435/3 "2018-06-05T18:43:58Z")

</div>

Hey @I_like_dogs, you can use a "must\_not" query to filter out items that don't match the items in an array ala:

```auto
{
  "query": {
    "bool": {
      "must_not": [
        {
          "terms": {
            "netflow.dst_port": [
              "53",
              "443"
            ]
          }
        }
      ]
    }
  }
}

```

---

<div class="post-metadata">

### Author: ![Magnus\_Kessler](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnus_kessler/32/42001_2.png) [@Magnus\_Kessler](https://discuss.elastic.co/u/Magnus_Kessler)
#### Post date: [June 5, 2018, 6:52pm UTC](https://discuss.elastic.co/t/adding-multiple-filters-at-once/134435/4 "2018-06-05T18:52:03Z")

</div>

You can [look up terms](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-terms-query.html#query-dsl-terms-lookup) you want to use in your filter from a document in an elasticsearch index. See the documentation for an [example](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-terms-query.html#_terms_lookup_twitter_example).

---

<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 3, 2018, 6:52pm UTC](https://discuss.elastic.co/t/adding-multiple-filters-at-once/134435/5 "2018-07-03T18:52:11Z")

</div>

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