# Partial search issue while string has numbers

**URL:** <https://discuss.elastic.co/t/partial-search-issue-while-string-has-numbers/50314>\
**Category:** Elasticsearch\
**Created:** [May 18, 2016, 8:22am UTC](https://discuss.elastic.co/t/partial-search-issue-while-string-has-numbers/50314 "2016-05-18T08:22:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![soorajhere](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/soorajhere/32/8396_2.png) [@soorajhere](https://discuss.elastic.co/u/soorajhere)\
**Post date:** [May 18, 2016, 8:22am UTC](https://discuss.elastic.co/t/partial-search-issue-while-string-has-numbers/50314/1 "2016-05-18T08:22:46Z")

</div>

Hi All,

I am facing an issue in ES search. I have few records indexed in ES and it contains numbers in it. I am unable to do filtering (partial search) while search string reaches numbers. Here is a sample

President building 12A main road  
President building 11 state highway  
President building 1 north site

If the above are records present and i am searching with President building 1, i am getting only one record (3rd one). Ideally it should return all the three records? right?. What am i missing here? Any help is appreciated.

Also i am able to see all three records when i type 'President building', and after that when number is entered, filtering is not happening. Only one record is displayed.  
i use search query with multi\_match and mention the fields and type as phrase prefix.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 19, 2016, 1:00pm UTC](https://discuss.elastic.co/t/partial-search-issue-while-string-has-numbers/50314/2 "2016-05-19T13:00:58Z")

</div>

What does your query actually look like?

---

<div class="post-metadata">

**Author:** ![soorajhere](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/soorajhere/32/8396_2.png) [@soorajhere](https://discuss.elastic.co/u/soorajhere)\
**Post date:** [May 31, 2016, 6:03am UTC](https://discuss.elastic.co/t/partial-search-issue-while-string-has-numbers/50314/3 "2016-05-31T06:03:04Z")

</div>

Hi Warkolm,

Thanks for your reply,

The query is a multi search query as shown below.

{"query":{"multi\_match":{"fields": ["StreetName", "CityName","HouseNo"],"query":"President building 1","type":"phrase\_prefix"}}}

this query should ideally return all three records  
President building 12A main road  
President building 11 state highway  
President building 1 north site  
correct?  
But only one record 'President building 1 north site ' is returned. why?

---

<div class="post-metadata">

**Author:** ![soorajhere](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/soorajhere/32/8396_2.png) [@soorajhere](https://discuss.elastic.co/u/soorajhere)\
**Post date:** [June 2, 2016, 5:55am UTC](https://discuss.elastic.co/t/partial-search-issue-while-string-has-numbers/50314/4 "2016-06-02T05:55:23Z")

</div>

Any help please?

---

<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 5, 2017, 10:47pm UTC](https://discuss.elastic.co/t/partial-search-issue-while-string-has-numbers/50314/5 "2017-07-05T22:47:02Z")

</div>