# How to implement a "is not one of " filter by using Query DSL
**URL:** https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830
**Category:** Kibana
**Created:** [December 21, 2017, 1:44pm UTC](https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830 "2017-12-21T13:44:39Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@jeremyasm](https://discuss.elastic.co/u/jeremyasm)
#### Post date: [December 21, 2017, 1:44pm UTC](https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830/1 "2017-12-21T13:44:39Z")
Hi,
We'd like to implement a "is not one of " filter by using Query DSL because there're so many items in "is not one of" List.
And we want to reuse the filter in many other dashboards, so writing Query DSL would be much easier, otherwise we have to type the items again and again for each dashboards.
I tried to use "must\_not", but error occured.
Thanks !
---
### Author:  [@chrisronline](https://discuss.elastic.co/u/chrisronline)
#### Post date: [December 21, 2017, 5:01pm UTC](https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830/2 "2017-12-21T17:01:54Z")
Hi @jeremyasm,
I might misunderstand your question, but you could query for something like:
`doc.garage_name: (-Canada -Communications)` and that should work. Then, you can save that as a saved search and build visualizations from that.
Does that help?
Thanks,
Chris
---
### Author:  [@jeremyasm](https://discuss.elastic.co/u/jeremyasm)
#### Post date: [December 26, 2017, 8:20am UTC](https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830/3 "2017-12-26T08:20:12Z")
I'd like to edit an Elasticsearch Query DSL rather than a filter.
Could you please give me a sample of "is not one of" query ?
---
### Author:  [@jeremyasm](https://discuss.elastic.co/u/jeremyasm)
#### Post date: [December 27, 2017, 9:43am UTC](https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830/4 "2017-12-27T09:43:53Z")
{
"query": {
"bool": {
"must\_not": {
"terms": {
"doc.garage\_name.keyword": [
"Canada",
"Communication",
"USA"
]
}
}
}
}
}
This is what I want, by using this Query DSL, I exclude docs of which the garage\_name is "Canada", "USA", "Communication"
---
### Author:  [@chrisronline](https://discuss.elastic.co/u/chrisronline)
#### Post date: [January 2, 2018, 2:51pm UTC](https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830/5 "2018-01-02T14:51:03Z")
@jeremyasm Great, so all set?
---
### Author:  [@jeremyasm](https://discuss.elastic.co/u/jeremyasm)
#### Post date: [January 3, 2018, 9:21am UTC](https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830/6 "2018-01-03T09:21:36Z")
@chrisronline
Yes.
Happy New Year !
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 31, 2018, 9:21am UTC](https://discuss.elastic.co/t/how-to-implement-a-is-not-one-of-filter-by-using-query-dsl/112830/7 "2018-01-31T09:21:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.