Indexed number column not in search results

Michelle Oswell 0 Reputation points
2023-03-08T17:48:16.54+00:00

I have two Sharepoint lists I've created where I'm experiencing the same issue in searching.

In one, I have a column called "case number" with a column type "number." The field is required but unique values aren't enforced and don't need to be. I added this column to the Indexed columns list as a primary column with no secondary column. I have waited plenty of time for the indexing to happen, but I still get no results when I search for a known case number in the list.

In this same list, I have another number field that is indexed and that produces results on searches.

At first, I thought it might be a problem due to the size of the list (it's over 5000 items), but all my views are below the 5000 item threshold.

However, I made another, smaller list (fewer than 1000 items) a few days ago on my subsite with a column called "base account" that is also a number column type (required and unique values are not enforced). I indexed this column too. And I get no results when searching on that field for known items. Keyword searching works, searching on choice columns works, but this number column isn't.

Both lists were created using the import from an Excel file option. In both cases, filtering the column works but it's not ideal. Search would be the preferred way of finding these account/case numbers.

Does anyone have any suggestions as to why this isn't working?

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,738 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,565 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Haoyan Xue_MSFT 19,481 Reputation points Microsoft Vendor
    2023-03-09T08:51:55.2333333+00:00

    Hi @Michelle Oswell

    I tested according to your description, I encountered the same situation as you, added Indexed columns and then searched, but didn't get any results. But if using another column that is indexed, everything works fine. This is because sharepoint needs to automatically crawl to update the searched results, but Microsoft has no clear definition for the crawling time, and the completion time will be determined according to the amount of content on your website. For example, on my test site, I observed it all afternoon, but my search results were still not updated. It is recommended that you wait patiently for the crawl to complete to ensure the freshness of the search results.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Haoyan Xue_MSFT 19,481 Reputation points Microsoft Vendor
    2023-03-17T07:37:44.25+00:00

    Hi @Michelle Oswell

    I researched again, maybe you can use Manage Properties Name in Search Schema as a prefix to search.

    For example: User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.