how to set a query for like query in azure search query syntax?

Question

I am trying azure search from my project and i am trying the following

 indexClient.Documents.Search<AuctionResult>("john", new SearchParameters { IncludeTotalResultCount = true, Filter = "SoldDate ge 2017-04-06 and SoldDate le 2017-04-06 and substringof(Title, '2007')" });

what i need is i need to filter the result based on the field Title, if Title contains the text '2007', it should be included.

what went wrong for me, what change should i make?

What happens with this query?any error? No result? Unexpected result? — Chetan, Apr 20 '17 at 05:30
It means that function `substringof` is not supported when you perform search this way. — Chetan, Apr 20 '17 at 13:11
@hildasonica Can you give an example of your Title field contents? Is 2007 one of the terms in this field (e.g. "Budget 2007"), or is it part of a single term (e.g. "budget2007.xlsx")? — Bruce Johnston, Apr 20 '17 at 15:44
@hildasonica Thanks. It would help clarify things if you gave examples in your original question. — Bruce Johnston, Apr 21 '17 at 15:34
Possible duplicate of [Azure Search - Find matches within a word like "contains"](http://stackoverflow.com/questions/40893802/azure-search-find-matches-within-a-word-like-contains) — Bruce Johnston, Apr 21 '17 at 15:34

score 3 · Accepted Answer · answered Oct 31 '17 at 12:25

3

at last i found the solution

so we should use the following in the query

search.ismatch('searchQuery',Search_feild)"

so

"SoldDate ge 2017-04-06 and SoldDate le 2017-04-06 and search.ismatch('2007','Title')"

answered Oct 31 '17 at 12:25

hilda_sonica_vish

727
3
10
31

score 0 · Answer 2 · edited May 23 '17 at 11:54

0

You can use a regex query to search within words. See the answer to this question for details.

edited May 23 '17 at 11:54

Community

1
1

answered Apr 21 '17 at 15:37

Bruce Johnston

8,344
3
32
42

how to set a query for like query in azure search query syntax?

2 Answers2

Linked