# How to filter exact terms?

**URL:** https://discuss.elastic.co/t/how-to-filter-exact-terms/32837
**Category:** Kibana
**Created:** [October 23, 2015, 9:51am UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837 "2015-10-23T09:51:13Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![abhijitdeka11](https://avatars.discourse-cdn.com/v4/letter/a/c5a1d2/32.png) [@abhijitdeka11](https://discuss.elastic.co/u/abhijitdeka11)
#### Post date: [October 23, 2015, 9:51am UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837/1 "2015-10-23T09:51:13Z")

</div>

Hi,

I struggling to do the following

 ![](https://us1.discourse-cdn.com/elastic/original/2X/c/ca6eafa421f62296285d8349933d9fe137dcd2d6.png)

I want to match the product field exactly with product=" **abc**" but not with any super string" **abcd**" or sub string " **ab**".The product field is already **Not Analysed** in elasticsearch.  
How do I achieve this?

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [October 26, 2015, 1:12am UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837/2 "2015-10-26T01:12:36Z")

</div>

Syntax is **field\_name:"exact\_value"**

Even with an analyzed field, here is what happens when you filter just by a string without quotes:

 ![](https://us1.discourse-cdn.com/elastic/original/2X/1/197bdb2cae4efe58703faa25c8887fbbcd28755d.png)

Versus for a string with quotes:

 ![](https://us1.discourse-cdn.com/elastic/original/2X/3/35948b25291b8c53731bbf2935dcfc6981bf12f4.png)

---

<div class="post-metadata">

### Author: ![abhijitdeka11](https://avatars.discourse-cdn.com/v4/letter/a/c5a1d2/32.png) [@abhijitdeka11](https://discuss.elastic.co/u/abhijitdeka11)
#### Post date: [October 26, 2015, 4:13am UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837/3 "2015-10-26T04:13:54Z")

</div>

Thanks for the reply. But how to get rid of something like "Winddows 8 ultimate".In your example."Windows 8" with quotes will show "Winddows 8 ultimate" also.I am not able to figure that out.I just want exact "Windows 8" not the super string "Winddows 8 ultimate"

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [October 26, 2015, 4:24am UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837/4 "2015-10-26T04:24:30Z")

</div>

If your field is analyzed, what you said above is true. If it's not analyzed, then only the exact copies should be retrieved (see below).

 ![](https://us1.discourse-cdn.com/elastic/original/2X/1/1f7135af6ecda0e7533bda9699c44cd83d5edf7d.png)

 ![](https://us1.discourse-cdn.com/elastic/original/2X/5/57500fa266fc4761ef195e05831b4ff555ceb8d3.png)

---

<div class="post-metadata">

### Author: ![abhijitdeka11](https://avatars.discourse-cdn.com/v4/letter/a/c5a1d2/32.png) [@abhijitdeka11](https://discuss.elastic.co/u/abhijitdeka11)
#### Post date: [October 26, 2015, 4:56am UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837/5 "2015-10-26T04:56:38Z")

</div>

Thanks for the reply.  
I guess I am doing something wrong.I am still getting all the items even if they are Not\_Analyzed. Please see the settings

 ![](https://us1.discourse-cdn.com/elastic/original/2X/7/762c724a79bfc60981875fb84609684dc51de2ff.png)

I am using this template for elasticsearch  
[file](https://www.dropbox.com/s/8h7vll6v2j2sqti/template.json?dl=0)

---

<div class="post-metadata">

### Author: ![abhijitdeka11](https://avatars.discourse-cdn.com/v4/letter/a/c5a1d2/32.png) [@abhijitdeka11](https://discuss.elastic.co/u/abhijitdeka11)
#### Post date: [October 26, 2015, 5:47am UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837/6 "2015-10-26T05:47:39Z")

</div>

I got the issue.I was passing Product="abc" instead of Product:abc.  
Thanks for the reply.

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [October 26, 2015, 3:42pm UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837/7 "2015-10-26T15:42:51Z")

</div>

Great! Glad that worked 😄

---

<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 6, 2017, 2:10pm UTC](https://discuss.elastic.co/t/how-to-filter-exact-terms/32837/8 "2017-07-06T14:10:41Z")

</div>


