I have a question about the validity of search results being returned in a SharePoint Server 2019 environment.
Here is an example of the scenario:
- I've created a list with about 10 columns. There is a single line of text column that includes a series of 1 or more 6-character, alpha-numeric codes which are used to uniquely identify people. When there is more than one code, the codes are currently separated by space. They were previously separated by a semi-colon, and I had the same issue I'm having now as described below.
- If I search the list's All Items view using one of the 6-character codes, the search does not return all list items that match the search criteria. It will only return partial results -- some where the specified code is the only code in the column and others where the specified code is one of several codes in the column.
- I've created a column index for this single line of text column, and I created a view filtered to only include list items that contain a specific code. The view results do include all of the matching list items. This is good.
- However, if I search the list view (using the "Find an item" box) by the same value that it is filtered by in the view design, then again it only finds partial results and thus decreases the number of list items shown in the view even though the search criteria is exactly the same as the view's filter criteria.
I'm stumped trying to figure out how to make sense of this or how to make the searching actually work and find all results.
On more than on occasion, I've clicked the list's "Reindex" button, and/or re-crawled the entire site, and/or reset the index at the site-collection level followed by full crawl, but none of this seems to help. We've even built a separate / clean environment to test this with, and have the same issue on both servers.
What's going on?
