Hello,

I have a SharePoint list that I use a directory for staff.  A full crawl has been many times, but when I get wrong results.

I have 100 records, and I have a column named "Department".  75 are in one department, while 25 are in another.  When I search for "Accounting" which would get me the 25 employees, I see some of the "Sales and Marketing" people show up.  I am using a text box search when I can type in Accounting for the division.

With the records that appear, there is no "Accounting" in any of the fields for these records that appear.  They are sales people, and there is no "Accounting" in any other fields, like name, email, phone and address.

What could be causing the incorrect search results?   

Hi Paul,

The suspected wrong results must be having the keyword in one of their fields. Else they should not come in the results.

Check if the below approach works for you.

1. Create a Managed Property (in Search Schema), and the crawled property of the Department column.

2. Name the Managed Property as 'Dept' or 'Department'. Make sure you check the Queryable text box for this managed property.

3. Run a full crawl.

4. Now you can search in the search box like - 'Dept:Accounting'. This instructs the search engine to query for that text only from the Department column. So, you can find more accurate results.

This way you can create more relevant managed properties. Hope this helps.