I am confused on how sharepoint 2013 enterprise search works, mainly when it comes to search for sub-strings. now i got this confusing scenario :-

I have the following item details:-

enter image description here

where is got a field named "JiraNumber", and its value = "For seasons".

now i did the following search inside my advance search web part , which produce the following search query :-


and I got the above item inside the results, as follow:-

enter image description here

which mean sharepoint have match a substring "season" to "seasons".

so i tried the following search query:-


but i did not get any result... although the above item have its description as "approved" .. so why sharepoint did not match the substring "approve" to match "approved", as it did for "season" and "seasons"??

  • 1
    Is the Jira Number column indexed by any chance? On the list/library settings page, click on "Indexed Columns" under the Columns section.
    – Ray Hogan
    Dec 9, 2016 at 14:01
  • @RayHogan i do not have any index on the list "_You have created 0 of maximum 20 indices on this list. These indices are: _"
    – John John
    Dec 9, 2016 at 17:04
  • 1
    If you do ANY(approved) do you get results?
    – Ray Hogan
    Dec 9, 2016 at 17:05
  • @RayHogan yes i will get all the items which have their statues as "approved" .. bu if i do ANY(approve) will not get any thing
    – John John
    Dec 9, 2016 at 17:22

1 Answer 1


You shouldn't be using the ANY operand as it was deprecated on SharePoin 2013. This means that it won't be supported in the future. Please check out the official documentation here.

Instead of ANY you can use OR, but in your case the query will simply work if you use JiraNumber:"for seasons" or JiraNumber:"season*". Note the * at the end. With this you are telling SharePoint that you want to find results that match the "season" prefix. That would work with Description as well. You would type Description:approve* and you should have the Project E being displayed. Finally, you can also type approve* and SharePoint will look in all fields not only Description.

-Hope this helps.

  • i am not sure if ANY is deprecated in SP2013, as the ANY will be used inside the built-in advance search web part, which is found inside the enterprise search center site collection template.. so i am not really using it explicitly or i chose to use it ,,but instead it is being used by the built-in advance search web part inside the built-in enterprise search site collection template, when you want to search for item that contain somthing
    – John John
    Dec 12, 2016 at 2:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.