Need Azure Search Lucene Query to Search the Records with following Scenario












-1















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




  1. Microsoft Visual Studio 32bit

  2. Microsoft Visual Basic Editor

  3. Microsoft SQL Server

  4. SQL Server Management Studio

  5. Visual Studio Code


My requirements are -



If User searches "SQL" then User should get results like




  1. SQL Server Management Studio

  2. 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




  1. Microsoft Visual Studio 32bit

  2. 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




  1. Microsoft Visual Studio 32bit

  2. Microsoft Visual Basic Editor

  3. Microsoft SQL Server


enter image description here










share|improve this question





























    -1















    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




    1. Microsoft Visual Studio 32bit

    2. Microsoft Visual Basic Editor

    3. Microsoft SQL Server

    4. SQL Server Management Studio

    5. Visual Studio Code


    My requirements are -



    If User searches "SQL" then User should get results like




    1. SQL Server Management Studio

    2. 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




    1. Microsoft Visual Studio 32bit

    2. 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




    1. Microsoft Visual Studio 32bit

    2. Microsoft Visual Basic Editor

    3. Microsoft SQL Server


    enter image description here










    share|improve this question



























      -1












      -1








      -1








      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




      1. Microsoft Visual Studio 32bit

      2. Microsoft Visual Basic Editor

      3. Microsoft SQL Server

      4. SQL Server Management Studio

      5. Visual Studio Code


      My requirements are -



      If User searches "SQL" then User should get results like




      1. SQL Server Management Studio

      2. 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




      1. Microsoft Visual Studio 32bit

      2. 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




      1. Microsoft Visual Studio 32bit

      2. Microsoft Visual Basic Editor

      3. Microsoft SQL Server


      enter image description here










      share|improve this question
















      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




      1. Microsoft Visual Studio 32bit

      2. Microsoft Visual Basic Editor

      3. Microsoft SQL Server

      4. SQL Server Management Studio

      5. Visual Studio Code


      My requirements are -



      If User searches "SQL" then User should get results like




      1. SQL Server Management Studio

      2. 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




      1. Microsoft Visual Studio 32bit

      2. 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




      1. Microsoft Visual Studio 32bit

      2. Microsoft Visual Basic Editor

      3. Microsoft SQL Server


      enter image description here







      azure lucene full-text-search lucene.net azure-search






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Dec 19 '18 at 13:25







      sudarshan1933

















      asked Nov 16 '18 at 17:59









      sudarshan1933sudarshan1933

      164




      164
























          2 Answers
          2






          active

          oldest

          votes


















          0














          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





          share|improve this answer


























          • 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 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





















          0














          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






          share|improve this answer
























          • 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











          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
          });


          }
          });














          draft saved

          draft discarded


















          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









          0














          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





          share|improve this answer


























          • 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 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


















          0














          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





          share|improve this answer


























          • 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 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
















          0












          0








          0







          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





          share|improve this answer















          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






          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 23 '18 at 6:25

























          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 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





















          • 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 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



















          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















          0














          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






          share|improve this answer
























          • 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
















          0














          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






          share|improve this answer
























          • 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














          0












          0








          0







          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






          share|improve this answer













          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







          share|improve this answer












          share|improve this answer



          share|improve this answer










          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 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



















          • 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

















          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


















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          Contact image not getting when fetch all contact list from iPhone by CNContact

          count number of partitions of a set with n elements into k subsets

          A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks