# Problem with search email field

**URL:** <https://discuss.elastic.co/t/problem-with-search-email-field/7022>\
**Category:** Elasticsearch\
**Created:** [March 15, 2012, 8:46pm UTC](https://discuss.elastic.co/t/problem-with-search-email-field/7022 "2012-03-15T20:46:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![steam](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@steam](https://discuss.elastic.co/u/steam)\
**Post date:** [March 15, 2012, 8:46pm UTC](https://discuss.elastic.co/t/problem-with-search-email-field/7022/1 "2012-03-15T20:46:37Z")

</div>

Hello, i'll appreciate a lot if someone can help me.  
I have one problem with search field (email) by term. I was building by java api index like

```
XContentBuilder jsonBuilder = jsonBuilder()
  	.startObject()
  	.field(ItemConstant.FIELD_PROV_ID, item.getProvinceId())
  	.field(ItemConstant.FIELD_PROV_DESC, item.getProvinceDesc())
  	.field(ItemConstant.FIELD_TITLE, item.getTitle())
  	.field(ItemConstant.FIELD_IMG_DIR, item.getImgDir())
  	.field(ItemConstant.FIELD_MAIL, item.getMail())
  	.endObject();

```

and then i trying to find by mail on elastic items

```
		queryBuilder = boolQuery().must(termQuery(ItemConstant.FIELD_MAIL, search.getMail()));
		searchRequestBuilder.setQuery(queryBuilder);

	searchRequestBuilder.setFrom(search.getStartRowIndex())
	.setSize(search.getNumRows()).setExplain(true);
	
	//EXECUTE SEARCH
	response = searchRequestBuilder.execute().actionGet();

```

but nothing have found on response.  
I think it must to be related with analizer, but i don't know where it apply to save field as is.  
And if i search only with a word until @ it find the item.

Can someone help me please. Thanks.

---

<div class="post-metadata">

**Author:** ![canavar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/canavar/32/2950_2.png) [@canavar](https://discuss.elastic.co/u/canavar)\
**Post date:** [March 15, 2012, 9:17pm UTC](https://discuss.elastic.co/t/problem-with-search-email-field/7022/2 "2012-03-15T21:17:26Z")

</div>

I think you should use a fieldQuery instead of termQuery.

On Thursday, March 15, 2012 10:46:37 PM UTC+2, steam wrote:

> Hello, i'll appreciate a lot if someone can help me.  
> I have one problem with search field (email) by term. I was building by  
> java  
> api index like
> 
> ```
> XContentBuilder jsonBuilder = jsonBuilder()
> .startObject()
> .field(ItemConstant.FIELD_PROV_ID, item.getProvinceId())
> .field(ItemConstant.FIELD_PROV_DESC, 
> 
> ```
> 
> item.getProvinceDesc())  
> .field(ItemConstant.FIELD\_TITLE, item.getTitle())  
> .field(ItemConstant.FIELD\_IMG\_DIR, item.getImgDir())  
> .field(ItemConstant.FIELD\_MAIL, item.getMail())  
> .endObject();
> 
> and then i trying to find by mail on elastic items
> 
> ```
> queryBuilder = 
> 
> ```
> 
> boolQuery().must(termQuery(ItemConstant.FIELD\_MAIL,  
> search.getMail()));  
> searchRequestBuilder.setQuery(queryBuilder);
> 
> ```
> searchRequestBuilder.setFrom(search.getStartRowIndex())
> .setSize(search.getNumRows()).setExplain(true);
>             
> //EXECUTE SEARCH
> response = searchRequestBuilder.execute().actionGet();
> 
> ```
> 
> but nothing have found on response.  
> I think it must to be related with analizer, but i don't know where it  
> apply  
> to save field as is.  
> And if i search only with a word until @ it find the item.
> 
> Can someone help me please. Thanks.
> 
> --  
> View this message in context:  
> [http://elasticsearch-users.115913.n3.nabble.com/Problem-with-search-email-field-tp3829982p3829982.html](http://elasticsearch-users.115913.n3.nabble.com/Problem-with-search-email-field-tp3829982p3829982.html)  
> Sent from the Elasticsearch Users mailing list archive at [Nabble.com](http://Nabble.com).

---

<div class="post-metadata">

**Author:** ![steam](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@steam](https://discuss.elastic.co/u/steam)\
**Post date:** [March 16, 2012, 4:13pm UTC](https://discuss.elastic.co/t/problem-with-search-email-field/7022/3 "2012-03-16T16:13:36Z")

</div>

Many thanks !!! It is working with fieldQuery.  
Thanks for suggestion !

2012/3/15 canavar [via Elasticsearch Users]  
[ml-node+s115913n3830072h26@n3.nabble.com](mailto:ml-node+s115913n3830072h26@n3.nabble.com):

> I think you should use a fieldQuery instead of termQuery.
> 
> On Thursday, March 15, 2012 10:46:37 PM UTC+2, steam wrote:
> 
> > Hello, i'll appreciate a lot if someone can help me.  
> > I have one problem with search field (email) by term. I was building by  
> > java  
> > api index like
> > 
> > ```
> > XContentBuilder jsonBuilder = jsonBuilder()
> > .startObject()
> > .field(ItemConstant.FIELD_PROV_ID, item.getProvinceId())
> > .field(ItemConstant.FIELD_PROV_DESC,
> > 
> > ```
> > 
> > item.getProvinceDesc())  
> > .field(ItemConstant.FIELD\_TITLE, item.getTitle())  
> > .field(ItemConstant.FIELD\_IMG\_DIR, item.getImgDir())  
> > .field(ItemConstant.FIELD\_MAIL, item.getMail())  
> > .endObject();
> > 
> > and then i trying to find by mail on elastic items
> > 
> > ```
> > queryBuilder =
> > 
> > ```
> > 
> > boolQuery().must(termQuery(ItemConstant.FIELD\_MAIL,  
> > search.getMail()));  
> > searchRequestBuilder.setQuery(queryBuilder);
> > 
> > ```
> > searchRequestBuilder.setFrom(search.getStartRowIndex())
> > .setSize(search.getNumRows()).setExplain(true);
> > 
> > //EXECUTE SEARCH
> > response = searchRequestBuilder.execute().actionGet();
> > 
> > ```
> > 
> > but nothing have found on response.  
> > I think it must to be related with analizer, but i don't know where it  
> > apply  
> > to save field as is.  
> > And if i search only with a word until @ it find the item.
> > 
> > Can someone help me please. Thanks.
> > 
> > --  
> > View this message in context:  
> > [http://elasticsearch-users.115913.n3.nabble.com/Problem-with-search-email-field-tp3829982p3829982.html](http://elasticsearch-users.115913.n3.nabble.com/Problem-with-search-email-field-tp3829982p3829982.html)  
> > Sent from the Elasticsearch Users mailing list archive at [Nabble.com](http://Nabble.com).
> 
> * * *
> 
> If you reply to this email, your message will be added to the discussion  
> below:  
> [http://elasticsearch-users.115913.n3.nabble.com/Problem-with-search-email-field-tp3829982p3830072.html](http://elasticsearch-users.115913.n3.nabble.com/Problem-with-search-email-field-tp3829982p3830072.html)  
> To unsubscribe from Problem with search email field., click here.  
> NAML

---

<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, 3:35am UTC](https://discuss.elastic.co/t/problem-with-search-email-field/7022/4 "2017-07-06T03:35:55Z")

</div>


