SharePoint list search box does not return correct results


down vote



I have a SharePoint list and I am using a view to display on a page. I am using SharePoint 2013. I have a 100 records in the list, and I am using the search box that gets turned on with the webpart option. This list has 10 columns and about 100 records, but when I type in a text some text to search for a particular column, I get 6 wrong records.

I checked these records and the search string is not in those 6 records. I have done a full crawl and have deleted the 6 records and recreated them, but they still get returned as results when they are not supposed to.

Any ideas what could be going wrong?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
Something is being matched. Is there any way to could provide the full row values and the search term?

Maybe filter those rows in a view and export to excel? Paste the rows from that?
PBITAuthor Commented:
The list has email addresses and staff names in. I will have to trim it down for security reasons.
Jamie McAllister MVPSharePoint ConsultantCommented:
That's reasonable. I'm just thinking that some string fragments may match somewhere in the data. The fact you recreate and still get hits support this idea.
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

PBITAuthor Commented:
Here is the directory.
Jamie McAllister MVPSharePoint ConsultantCommented:
Whats the search term and which rows match falsely?
PBITAuthor Commented:
I was searching the Division column.  Searching string would be PBTF.  

Rows 12, 32, 33, 41, 76 and 61.
PBITAuthor Commented:
I should say rows 12, 32, 33, 41, 76 and 61 show up when you search for PBTF division.  These people are not in the PBTF division.

The problem is only with the search box for the view.  The column filter/data selectors work great and show accurate results. However, the search box does not.
Jamie McAllister MVPSharePoint ConsultantCommented:
When you say 'Search box for the view' do you mean the standard search box on the page?

I don't see anything in the data that's really obvious, but then it's been obfuscated.

btw this can be a great alternative to classic search for list views;

I use this in a variety of lists and libs.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PBITAuthor Commented:
We are planning to delete the list and start over.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.