Need Azure Search Lucene Query to Search the Records with following Scenario
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have Azure search Index which has column as ProductName.
I have to show the ProductName based on how user searchs. So How Can I form the query if I want to search in between word.
ProductName
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
- Microsoft SQL Server
- SQL Server Management Studio
- Visual Studio Code
My requirements are -
If User searches "SQL" then User should get results like
- SQL Server Management Studio
- Microsoft SQL Server
Solution -
For this Scenario, I am calling my Azure Search Index as and it works
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=/.*SQL.*/&queryType=full&$select=ProductName
==============================================
Second Scenario - If User searches "Microsoft Vis"
User should get two results
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
How Can I get this Result?
How to create a Query. I already search for My First Scenario But For my second scenario, I am stuck. Please help.
If I search Like this
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
==============================================================
Third Scenario - If User search for "soft" I need to show these results
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
- Microsoft SQL Server
azure lucene full-text-search lucene.net azure-search asked Nov 16 '18 at 17:59
sudarshan1933sudarshan1933
165
add a comment |
I have Azure search Index which has column as ProductName.
I have to show the ProductName based on how user searchs. So How Can I form the query if I want to search in between word.
ProductName
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
- Microsoft SQL Server
- SQL Server Management Studio
- Visual Studio Code
My requirements are -
If User searches "SQL" then User should get results like
- SQL Server Management Studio
- Microsoft SQL Server
Solution -
For this Scenario, I am calling my Azure Search Index as and it works
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=/.*SQL.*/&queryType=full&$select=ProductName
==============================================
Second Scenario - If User searches "Microsoft Vis"
User should get two results
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
How Can I get this Result?
How to create a Query. I already search for My First Scenario But For my second scenario, I am stuck. Please help.
If I search Like this
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
==============================================================
Third Scenario - If User search for "soft" I need to show these results
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
- Microsoft SQL Server
azure lucene full-text-search lucene.net azure-search asked Nov 16 '18 at 17:59
sudarshan1933sudarshan1933
165
add a comment |
I have Azure search Index which has column as ProductName.
I have to show the ProductName based on how user searchs. So How Can I form the query if I want to search in between word.
ProductName
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
- Microsoft SQL Server
- SQL Server Management Studio
- Visual Studio Code
My requirements are -
If User searches "SQL" then User should get results like
- SQL Server Management Studio
- Microsoft SQL Server
Solution -
For this Scenario, I am calling my Azure Search Index as and it works
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=/.*SQL.*/&queryType=full&$select=ProductName
==============================================
Second Scenario - If User searches "Microsoft Vis"
User should get two results
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
How Can I get this Result?
How to create a Query. I already search for My First Scenario But For my second scenario, I am stuck. Please help.
If I search Like this
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
==============================================================
Third Scenario - If User search for "soft" I need to show these results
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
- Microsoft SQL Server
azure lucene full-text-search lucene.net azure-search asked Nov 16 '18 at 17:59
sudarshan1933sudarshan1933
165
I have Azure search Index which has column as ProductName.
I have to show the ProductName based on how user searchs. So How Can I form the query if I want to search in between word.
ProductName
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
- Microsoft SQL Server
- SQL Server Management Studio
- Visual Studio Code
My requirements are -
If User searches "SQL" then User should get results like
- SQL Server Management Studio
- Microsoft SQL Server
Solution -
For this Scenario, I am calling my Azure Search Index as and it works
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=/.*SQL.*/&queryType=full&$select=ProductName
==============================================
Second Scenario - If User searches "Microsoft Vis"
User should get two results
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
How Can I get this Result?
How to create a Query. I already search for My First Scenario But For my second scenario, I am stuck. Please help.
If I search Like this
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
==============================================================
Third Scenario - If User search for "soft" I need to show these results
- Microsoft Visual Studio 32bit
- Microsoft Visual Basic Editor
- Microsoft SQL Server
azure lucene full-text-search lucene.net azure-search azure lucene full-text-search lucene.net azure-search asked Nov 16 '18 at 17:59
sudarshan1933sudarshan1933
165
asked Nov 16 '18 at 17:59
sudarshan1933sudarshan1933
165
edited Dec 19 '18 at 13:25
sudarshan1933
asked Nov 16 '18 at 17:59
sudarshan1933sudarshan1933
165
asked Nov 16 '18 at 17:59
sudarshan1933sudarshan1933
165
asked Nov 16 '18 at 17:59
sudarshan1933sudarshan1933
165
165
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You may try to call the following request url while searching "SQL"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
Or call this request url while searching "Microsoft Vis"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Vis*&searchMode=all&%24select=productName
If you type 'Microsoft Visual B', you could call the following api:
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Visual%20B*&searchMode=all&%24select=productName
answered Nov 20 '18 at 9:34
AndyAndy
215
Thanks @Andy - I got it. But If I search with "Microsoft Visual B" then also I am getting two ProductNames. Ideally, It should return only one, Microsoft Visual Basic Editor
– sudarshan1933
Nov 22 '18 at 10:36
What is another ProductName you get ?
– Andy
Nov 23 '18 at 3:12
If I type "Microsoft Visual B" and calls search api I am getting still getting both the Products Microsoft Visual Studio 32bit and Microsoft Visual Basic Editor
– sudarshan1933
Nov 23 '18 at 5:26
You may have forgotten to append * to the end of "Microsoft Visual B". You just change the search url param value to Microsoft%20Visual%20B*
– Andy
Nov 23 '18 at 6:43
-If I search like thishttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&querytype=full&searchmode=allIt returns following results"value": [ { "@search.score": 1, "ID": "46", "Name": "Microsoft SQL Server" }, { "@search.score": 1, "ID": "47", "Name": "SQL Server Management Studio" }, { "@search.score": 1, "ID": "51", "Name": "Microsoft SQL 32\64" } ]
– sudarshan1933
Nov 26 '18 at 9:09
add a comment |
Azure Search breaks text when indexed into pieces called "tokens" that amount to the smallest segment of text you can search for. An indexed word may result in multiple tokens depending on the analyzer selected for the field.
You should only need to provide a wildcard when you are you are looking for a token that begins with the text. This is not the same as a starts with for the full string in the index. In your examples, "SQL" would not need a wildcard. "Vis*" needs the wildcard since you are looking for "visual".
Let me know if you have any additional questions.
Mike Carter
Azure Search product team
answered Nov 27 '18 at 19:47
Mike Carter - MSFTMike Carter - MSFT
613
Thanks for comment. I have two requirements here. If User search for "soft" I need to show these results 1.Microsoft Visual Studio 32bit, 2. Microsoft Visual Basic Editor, 3.Microsoft SQL Server If User search for "Microsoft Vis" then it should show as per second scenario described in question. Hence I calling Azure search likehttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft vis* || /.*Microsoft vis.*/&queryType=full&searchMode=allIn short I am taking searchTerm in one Variable and I am calling search api.
– sudarshan1933
Dec 19 '18 at 13:14
Please let me know if you need more information.
– sudarshan1933
Dec 19 '18 at 13:23
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53343120%2fneed-azure-search-lucene-query-to-search-the-records-with-following-scenario%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You may try to call the following request url while searching "SQL"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
Or call this request url while searching "Microsoft Vis"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Vis*&searchMode=all&%24select=productName
If you type 'Microsoft Visual B', you could call the following api:
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Visual%20B*&searchMode=all&%24select=productName
answered Nov 20 '18 at 9:34
AndyAndy
215
Thanks @Andy - I got it. But If I search with "Microsoft Visual B" then also I am getting two ProductNames. Ideally, It should return only one, Microsoft Visual Basic Editor
– sudarshan1933
Nov 22 '18 at 10:36
What is another ProductName you get ?
– Andy
Nov 23 '18 at 3:12
If I type "Microsoft Visual B" and calls search api I am getting still getting both the Products Microsoft Visual Studio 32bit and Microsoft Visual Basic Editor
– sudarshan1933
Nov 23 '18 at 5:26
You may have forgotten to append * to the end of "Microsoft Visual B". You just change the search url param value to Microsoft%20Visual%20B*
– Andy
Nov 23 '18 at 6:43
-If I search like thishttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&querytype=full&searchmode=allIt returns following results"value": [ { "@search.score": 1, "ID": "46", "Name": "Microsoft SQL Server" }, { "@search.score": 1, "ID": "47", "Name": "SQL Server Management Studio" }, { "@search.score": 1, "ID": "51", "Name": "Microsoft SQL 32\64" } ]
– sudarshan1933
Nov 26 '18 at 9:09
add a comment |
You may try to call the following request url while searching "SQL"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
Or call this request url while searching "Microsoft Vis"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Vis*&searchMode=all&%24select=productName
If you type 'Microsoft Visual B', you could call the following api:
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Visual%20B*&searchMode=all&%24select=productName
answered Nov 20 '18 at 9:34
AndyAndy
215
Thanks @Andy - I got it. But If I search with "Microsoft Visual B" then also I am getting two ProductNames. Ideally, It should return only one, Microsoft Visual Basic Editor
– sudarshan1933
Nov 22 '18 at 10:36
What is another ProductName you get ?
– Andy
Nov 23 '18 at 3:12
If I type "Microsoft Visual B" and calls search api I am getting still getting both the Products Microsoft Visual Studio 32bit and Microsoft Visual Basic Editor
– sudarshan1933
Nov 23 '18 at 5:26
You may have forgotten to append * to the end of "Microsoft Visual B". You just change the search url param value to Microsoft%20Visual%20B*
– Andy
Nov 23 '18 at 6:43
-If I search like thishttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&querytype=full&searchmode=allIt returns following results"value": [ { "@search.score": 1, "ID": "46", "Name": "Microsoft SQL Server" }, { "@search.score": 1, "ID": "47", "Name": "SQL Server Management Studio" }, { "@search.score": 1, "ID": "51", "Name": "Microsoft SQL 32\64" } ]
– sudarshan1933
Nov 26 '18 at 9:09
add a comment |
You may try to call the following request url while searching "SQL"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
Or call this request url while searching "Microsoft Vis"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Vis*&searchMode=all&%24select=productName
If you type 'Microsoft Visual B', you could call the following api:
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Visual%20B*&searchMode=all&%24select=productName
answered Nov 20 '18 at 9:34
AndyAndy
215
You may try to call the following request url while searching "SQL"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&searchMode=all&%24select=productName
Or call this request url while searching "Microsoft Vis"
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Vis*&searchMode=all&%24select=productName
If you type 'Microsoft Visual B', you could call the following api:
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft%20Visual%20B*&searchMode=all&%24select=productName
answered Nov 20 '18 at 9:34
AndyAndy
215
edited Nov 23 '18 at 6:25
answered Nov 20 '18 at 9:34
AndyAndy
215
answered Nov 20 '18 at 9:34
AndyAndy
215
answered Nov 20 '18 at 9:34
AndyAndy
215
215
Thanks @Andy - I got it. But If I search with "Microsoft Visual B" then also I am getting two ProductNames. Ideally, It should return only one, Microsoft Visual Basic Editor
– sudarshan1933
Nov 22 '18 at 10:36
What is another ProductName you get ?
– Andy
Nov 23 '18 at 3:12
If I type "Microsoft Visual B" and calls search api I am getting still getting both the Products Microsoft Visual Studio 32bit and Microsoft Visual Basic Editor
– sudarshan1933
Nov 23 '18 at 5:26
You may have forgotten to append * to the end of "Microsoft Visual B". You just change the search url param value to Microsoft%20Visual%20B*
– Andy
Nov 23 '18 at 6:43
-If I search like thishttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&querytype=full&searchmode=allIt returns following results"value": [ { "@search.score": 1, "ID": "46", "Name": "Microsoft SQL Server" }, { "@search.score": 1, "ID": "47", "Name": "SQL Server Management Studio" }, { "@search.score": 1, "ID": "51", "Name": "Microsoft SQL 32\64" } ]
– sudarshan1933
Nov 26 '18 at 9:09
add a comment |
Thanks @Andy - I got it. But If I search with "Microsoft Visual B" then also I am getting two ProductNames. Ideally, It should return only one, Microsoft Visual Basic Editor
– sudarshan1933
Nov 22 '18 at 10:36
What is another ProductName you get ?
– Andy
Nov 23 '18 at 3:12
If I type "Microsoft Visual B" and calls search api I am getting still getting both the Products Microsoft Visual Studio 32bit and Microsoft Visual Basic Editor
– sudarshan1933
Nov 23 '18 at 5:26
You may have forgotten to append * to the end of "Microsoft Visual B". You just change the search url param value to Microsoft%20Visual%20B*
– Andy
Nov 23 '18 at 6:43
-If I search like thishttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&querytype=full&searchmode=allIt returns following results"value": [ { "@search.score": 1, "ID": "46", "Name": "Microsoft SQL Server" }, { "@search.score": 1, "ID": "47", "Name": "SQL Server Management Studio" }, { "@search.score": 1, "ID": "51", "Name": "Microsoft SQL 32\64" } ]
– sudarshan1933
Nov 26 '18 at 9:09
Thanks @Andy - I got it. But If I search with "Microsoft Visual B" then also I am getting two ProductNames. Ideally, It should return only one, Microsoft Visual Basic Editor
– sudarshan1933
Nov 22 '18 at 10:36
Thanks @Andy - I got it. But If I search with "Microsoft Visual B" then also I am getting two ProductNames. Ideally, It should return only one, Microsoft Visual Basic Editor
– sudarshan1933
Nov 22 '18 at 10:36
What is another ProductName you get ?
– Andy
Nov 23 '18 at 3:12
What is another ProductName you get ?
– Andy
Nov 23 '18 at 3:12
If I type "Microsoft Visual B" and calls search api I am getting still getting both the Products Microsoft Visual Studio 32bit and Microsoft Visual Basic Editor
– sudarshan1933
Nov 23 '18 at 5:26
If I type "Microsoft Visual B" and calls search api I am getting still getting both the Products Microsoft Visual Studio 32bit and Microsoft Visual Basic Editor
– sudarshan1933
Nov 23 '18 at 5:26
You may have forgotten to append * to the end of "Microsoft Visual B". You just change the search url param value to Microsoft%20Visual%20B*
– Andy
Nov 23 '18 at 6:43
You may have forgotten to append * to the end of "Microsoft Visual B". You just change the search url param value to Microsoft%20Visual%20B*
– Andy
Nov 23 '18 at 6:43
-If I search like this
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&querytype=full&searchmode=all It returns following results "value": [ { "@search.score": 1, "ID": "46", "Name": "Microsoft SQL Server" }, { "@search.score": 1, "ID": "47", "Name": "SQL Server Management Studio" }, { "@search.score": 1, "ID": "51", "Name": "Microsoft SQL 32\64" } ]– sudarshan1933
Nov 26 '18 at 9:09
-If I search like this
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=SQL*&querytype=full&searchmode=all It returns following results "value": [ { "@search.score": 1, "ID": "46", "Name": "Microsoft SQL Server" }, { "@search.score": 1, "ID": "47", "Name": "SQL Server Management Studio" }, { "@search.score": 1, "ID": "51", "Name": "Microsoft SQL 32\64" } ]– sudarshan1933
Nov 26 '18 at 9:09
add a comment |
Azure Search breaks text when indexed into pieces called "tokens" that amount to the smallest segment of text you can search for. An indexed word may result in multiple tokens depending on the analyzer selected for the field.
You should only need to provide a wildcard when you are you are looking for a token that begins with the text. This is not the same as a starts with for the full string in the index. In your examples, "SQL" would not need a wildcard. "Vis*" needs the wildcard since you are looking for "visual".
Let me know if you have any additional questions.
Mike Carter
Azure Search product team
answered Nov 27 '18 at 19:47
Mike Carter - MSFTMike Carter - MSFT
613
Thanks for comment. I have two requirements here. If User search for "soft" I need to show these results 1.Microsoft Visual Studio 32bit, 2. Microsoft Visual Basic Editor, 3.Microsoft SQL Server If User search for "Microsoft Vis" then it should show as per second scenario described in question. Hence I calling Azure search likehttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft vis* || /.*Microsoft vis.*/&queryType=full&searchMode=allIn short I am taking searchTerm in one Variable and I am calling search api.
– sudarshan1933
Dec 19 '18 at 13:14
Please let me know if you need more information.
– sudarshan1933
Dec 19 '18 at 13:23
add a comment |
Azure Search breaks text when indexed into pieces called "tokens" that amount to the smallest segment of text you can search for. An indexed word may result in multiple tokens depending on the analyzer selected for the field.
You should only need to provide a wildcard when you are you are looking for a token that begins with the text. This is not the same as a starts with for the full string in the index. In your examples, "SQL" would not need a wildcard. "Vis*" needs the wildcard since you are looking for "visual".
Let me know if you have any additional questions.
Mike Carter
Azure Search product team
answered Nov 27 '18 at 19:47
Mike Carter - MSFTMike Carter - MSFT
613
Thanks for comment. I have two requirements here. If User search for "soft" I need to show these results 1.Microsoft Visual Studio 32bit, 2. Microsoft Visual Basic Editor, 3.Microsoft SQL Server If User search for "Microsoft Vis" then it should show as per second scenario described in question. Hence I calling Azure search likehttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft vis* || /.*Microsoft vis.*/&queryType=full&searchMode=allIn short I am taking searchTerm in one Variable and I am calling search api.
– sudarshan1933
Dec 19 '18 at 13:14
Please let me know if you need more information.
– sudarshan1933
Dec 19 '18 at 13:23
add a comment |
Azure Search breaks text when indexed into pieces called "tokens" that amount to the smallest segment of text you can search for. An indexed word may result in multiple tokens depending on the analyzer selected for the field.
You should only need to provide a wildcard when you are you are looking for a token that begins with the text. This is not the same as a starts with for the full string in the index. In your examples, "SQL" would not need a wildcard. "Vis*" needs the wildcard since you are looking for "visual".
Let me know if you have any additional questions.
Mike Carter
Azure Search product team
answered Nov 27 '18 at 19:47
Mike Carter - MSFTMike Carter - MSFT
613
Azure Search breaks text when indexed into pieces called "tokens" that amount to the smallest segment of text you can search for. An indexed word may result in multiple tokens depending on the analyzer selected for the field.
You should only need to provide a wildcard when you are you are looking for a token that begins with the text. This is not the same as a starts with for the full string in the index. In your examples, "SQL" would not need a wildcard. "Vis*" needs the wildcard since you are looking for "visual".
Let me know if you have any additional questions.
Mike Carter
Azure Search product team
answered Nov 27 '18 at 19:47
Mike Carter - MSFTMike Carter - MSFT
613
answered Nov 27 '18 at 19:47
Mike Carter - MSFTMike Carter - MSFT
613
answered Nov 27 '18 at 19:47
Mike Carter - MSFTMike Carter - MSFT
613
answered Nov 27 '18 at 19:47
Mike Carter - MSFTMike Carter - MSFT
613
613
Thanks for comment. I have two requirements here. If User search for "soft" I need to show these results 1.Microsoft Visual Studio 32bit, 2. Microsoft Visual Basic Editor, 3.Microsoft SQL Server If User search for "Microsoft Vis" then it should show as per second scenario described in question. Hence I calling Azure search likehttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft vis* || /.*Microsoft vis.*/&queryType=full&searchMode=allIn short I am taking searchTerm in one Variable and I am calling search api.
– sudarshan1933
Dec 19 '18 at 13:14
Please let me know if you need more information.
– sudarshan1933
Dec 19 '18 at 13:23
add a comment |
Thanks for comment. I have two requirements here. If User search for "soft" I need to show these results 1.Microsoft Visual Studio 32bit, 2. Microsoft Visual Basic Editor, 3.Microsoft SQL Server If User search for "Microsoft Vis" then it should show as per second scenario described in question. Hence I calling Azure search likehttps://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft vis* || /.*Microsoft vis.*/&queryType=full&searchMode=allIn short I am taking searchTerm in one Variable and I am calling search api.
– sudarshan1933
Dec 19 '18 at 13:14
Please let me know if you need more information.
– sudarshan1933
Dec 19 '18 at 13:23
Thanks for comment. I have two requirements here. If User search for "soft" I need to show these results 1.Microsoft Visual Studio 32bit, 2. Microsoft Visual Basic Editor, 3.Microsoft SQL Server If User search for "Microsoft Vis" then it should show as per second scenario described in question. Hence I calling Azure search like
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft vis* || /.*Microsoft vis.*/&queryType=full&searchMode=all In short I am taking searchTerm in one Variable and I am calling search api.– sudarshan1933
Dec 19 '18 at 13:14
Thanks for comment. I have two requirements here. If User search for "soft" I need to show these results 1.Microsoft Visual Studio 32bit, 2. Microsoft Visual Basic Editor, 3.Microsoft SQL Server If User search for "Microsoft Vis" then it should show as per second scenario described in question. Hence I calling Azure search like
https://myindex.search.windows.net/indexes/myproducts/docs?api-version=2017-11-11&search=Microsoft vis* || /.*Microsoft vis.*/&queryType=full&searchMode=all In short I am taking searchTerm in one Variable and I am calling search api.– sudarshan1933
Dec 19 '18 at 13:14
Please let me know if you need more information.
– sudarshan1933
Dec 19 '18 at 13:23
Please let me know if you need more information.
– sudarshan1933
Dec 19 '18 at 13:23
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53343120%2fneed-azure-search-lucene-query-to-search-the-records-with-following-scenario%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
