# How to find distinct of 2 terms in ElasticSearch

**URL:** https://discuss.elastic.co/t/how-to-find-distinct-of-2-terms-in-elasticsearch/160212
**Category:** Elasticsearch
**Created:** [December 10, 2018, 4:12pm UTC](https://discuss.elastic.co/t/how-to-find-distinct-of-2-terms-in-elasticsearch/160212 "2018-12-10T16:12:04Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![murtazahzaveri](https://avatars.discourse-cdn.com/v4/letter/m/f14d63/32.png) [@murtazahzaveri](https://discuss.elastic.co/u/murtazahzaveri)
#### Post date: [December 10, 2018, 4:12pm UTC](https://discuss.elastic.co/t/how-to-find-distinct-of-2-terms-in-elasticsearch/160212/1 "2018-12-10T16:12:04Z")

</div>

I want to retrieve distinct value from document in elasticsearch on 2 terms...  
for example: my documents has department and College...so if i am searching on any state name so i should get distinct values based on both of it across all the documents which has that state..  
Result should look like as:  
state:california  
Result:::  
department:CS  
college:abc,  
department:IT  
college:abc,  
department:CS  
college:bcd,  
department:CS  
college:def,  
department:EXTC  
college:ABC

Thanks

---

<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: [January 7, 2019, 4:12pm UTC](https://discuss.elastic.co/t/how-to-find-distinct-of-2-terms-in-elasticsearch/160212/2 "2019-01-07T16:12:05Z")

</div>

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