locked
Partial Keyword Search Not Working RRS feed

  • Question

  • Hi,

    We are looking for a solution to search the partial words.

    Example:

    We have Product Numbers in a SharePoint list like 00100122, 00110120, 00100132, 00100152, 01100122

    When user search for 100, it doesn`t return the results.

    But expected results as 00100122, 00100132, 00100152, 01100122. Ideally user is looking for *100*.

    We have used KQL syntax to get results for our search implementation.

    We have gone through the MSDN articles and found suffix match won`t support.

    Can anyone help me to get this works.

    Thanks in advance.


    -Venkat

    Tuesday, March 31, 2015 6:12 AM

Answers

  • Hi Venkat,

    According to your description, my understanding is that you want to search using the partial words.

    When you search using partial words, SharePoint use these partial words as a string to query, it only returns the result which matches the string completely.

    If you want the keyword as a suffix or prefix to search, you need to add "*" as the prefix or suffix of keyword, like you said "*100*".

    Thanks,

    Wendy


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by Victoria Xia Wednesday, April 8, 2015 9:22 AM
    • Marked as answer by star.wars Sunday, April 12, 2015 4:09 PM
    Wednesday, April 1, 2015 7:03 AM
  • Hi Venkat,

    What I suggest you do is to modify the "query" of search webpart to append "*" after every user input. This would act as a wildcard search. Hope that helps!

    Syntax and details here https://technet.microsoft.com/en-us/library/jj679900.aspx

    Cheers

    Sudeep

    • Proposed as answer by Victoria Xia Wednesday, April 8, 2015 9:22 AM
    • Marked as answer by star.wars Sunday, April 12, 2015 4:09 PM
    Wednesday, April 1, 2015 8:31 AM

All replies

  • Hi Venkat,

    According to your description, my understanding is that you want to search using the partial words.

    When you search using partial words, SharePoint use these partial words as a string to query, it only returns the result which matches the string completely.

    If you want the keyword as a suffix or prefix to search, you need to add "*" as the prefix or suffix of keyword, like you said "*100*".

    Thanks,

    Wendy


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by Victoria Xia Wednesday, April 8, 2015 9:22 AM
    • Marked as answer by star.wars Sunday, April 12, 2015 4:09 PM
    Wednesday, April 1, 2015 7:03 AM
  • Hi Venkat,

    What I suggest you do is to modify the "query" of search webpart to append "*" after every user input. This would act as a wildcard search. Hope that helps!

    Syntax and details here https://technet.microsoft.com/en-us/library/jj679900.aspx

    Cheers

    Sudeep

    • Proposed as answer by Victoria Xia Wednesday, April 8, 2015 9:22 AM
    • Marked as answer by star.wars Sunday, April 12, 2015 4:09 PM
    Wednesday, April 1, 2015 8:31 AM