# Need an example to to multi value search

**URL:** <https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971>\
**Category:** Elasticsearch\
**Tags:** language-clients\
**Created:** [March 3, 2023, 11:10pm UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971 "2023-03-03T23:10:03Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![vkrishna](https://avatars.discourse-cdn.com/v4/letter/v/cab0a1/32.png) [@vkrishna](https://discuss.elastic.co/u/vkrishna)\
**Post date:** [March 3, 2023, 11:10pm UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971/1 "2023-03-03T23:10:03Z")

</div>

Hi Team,  
We need an example to to multi value search using **co.elastic.clients.elasticsearch.\_types.query\_dsl.Query.**  
Assume we have a field called " **rating**" in Elasticsearch.  
I want a JAVA Elasticsearch query written using **co.elastic.clients.elasticsearch.\_types.query\_dsl.Query**.

For example consider below example  
if query says rating= AA,B  
Record "rating" should have either AA or B  
then it should fetch records with id 1,2,4

* * *

[  
{ "id":1,  
"rating"="AA",  
"occupation":"Architect",  
"lender\_yield"=1.0  
},  
{ "id":2,  
"rating"="AA",  
"occupation":"Architect",  
"lender\_yield"=1.1  
},  
{ "id":3,  
"rating"="C",  
"occupation":"Analyst",  
"lender\_yield"=3.0  
},  
{ "id":4,  
"rating"="B",  
"occupation":"Analyst",  
"lender\_yield"=2.8  
},  
{ "id":5,  
"rating"="A",  
"occupation":"Analyst",  
"lender\_yield"=2.0  
}  
]

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 4, 2023, 1:46am UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971/2 "2023-03-04T01:46:07Z")

</div>

Welcome!

What about a match query with "AA B"?  
Or a simple\_query\_string query?

---

<div class="post-metadata">

**Author:** ![vkrishna](https://avatars.discourse-cdn.com/v4/letter/v/cab0a1/32.png) [@vkrishna](https://discuss.elastic.co/u/vkrishna)\
**Post date:** [March 4, 2023, 3:16am UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971/3 "2023-03-04T03:16:36Z")

</div>

Thanks for responding David.  
Yeah I would like to have sample example for both MatchQuery and simple\_query.  
Given query(AA,B) it should records with value either AA or B.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 4, 2023, 4:23am UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971/4 "2023-03-04T04:23:16Z")

</div>

Is there anything unclear in [the documentation](https://www.elastic.co/guide/en/elasticsearch/client/java-api-client/current/searching.html#_simple_search_query)?

---

<div class="post-metadata">

**Author:** ![vkrishna](https://avatars.discourse-cdn.com/v4/letter/v/cab0a1/32.png) [@vkrishna](https://discuss.elastic.co/u/vkrishna)\
**Post date:** [March 4, 2023, 4:25am UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971/5 "2023-03-04T04:25:26Z")

</div>

Example provided in the documentation does not contain searching using multiple values.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 4, 2023, 8:41am UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971/6 "2023-03-04T08:41:41Z")

</div>

I proposed searching for "AA B".

---

<div class="post-metadata">

**Author:** ![vkrishna](https://avatars.discourse-cdn.com/v4/letter/v/cab0a1/32.png) [@vkrishna](https://discuss.elastic.co/u/vkrishna)\
**Post date:** [March 4, 2023, 8:02pm UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971/7 "2023-03-04T20:02:40Z")

</div>

Thanks a lot David. It 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:** [April 1, 2023, 8:02pm UTC](https://discuss.elastic.co/t/need-an-example-to-to-multi-value-search/326971/8 "2023-04-01T20:02:55Z")

</div>

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