# Not able to Query alphanumeric fields from ELASTIC SEARCH using TERMS QUERY

**URL:** <https://discuss.elastic.co/t/not-able-to-query-alphanumeric-fields-from-elastic-search-using-terms-query/17691>\
**Category:** Elasticsearch\
**Created:** [May 23, 2014, 11:39am UTC](https://discuss.elastic.co/t/not-able-to-query-alphanumeric-fields-from-elastic-search-using-terms-query/17691 "2014-05-23T11:39:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kamdar\_mufaddal](https://avatars.discourse-cdn.com/v4/letter/k/ba9def/32.png) [@kamdar\_mufaddal](https://discuss.elastic.co/u/kamdar_mufaddal)\
**Post date:** [May 23, 2014, 11:39am UTC](https://discuss.elastic.co/t/not-able-to-query-alphanumeric-fields-from-elastic-search-using-terms-query/17691/1 "2014-05-23T11:39:45Z")

</div>

Hi,

I am trying to query Alphanumeric values from the index using TERMS QUERY, But it is not giving me the output.

Query:

{  
"size" : 10000,  
"query" : {  
"bool" : {  
"must" : {  
"terms" : {  
"caid" : ["A100945","A100896"]  
}  
}  
}  
},  
"fields" : ["acco", "bOS", "aid", "TTl", "caid"]  
}

I want to get all the entries that has caid A100945 or A100896

The same query works fine for NUmeric fields.

I am not planning to use QueryString/MatchQuery as i am trying to build general query builder that can build query for all the request. Hence am looking to get the entries usinng TERMS Query only.

Note: I am using Java API org.elasticsearch.index.query.QueryBuilders for building the Query.

eg: QueryBuilders.termQuery("caid", "["A10xxx", "A101xxx"]")

Please help.

Regards,  
Mik

---

<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, 1:27am UTC](https://discuss.elastic.co/t/not-able-to-query-alphanumeric-fields-from-elastic-search-using-terms-query/17691/2 "2017-07-06T01:27:26Z")

</div>