My scenario is:
- I have created a list, let's call it Customers, with a few columns, say CustomerID, CustomerName and CustomerTaxNr.
- Then there's the Document Library in which I've created a column of type Lookup, getting data from the Customers list. It shows one of the fields, say CustomerID, and I've done the "add additional columns from the list" to show the rest of the fields.
So far so good. Every document in the library is tagged with a CustomerID and shows the CustomerName and CustomerTaxNr as well.
But then we get to search.
With this configuration, users can search for CustomerID and find the relevant documents. But searching for customer name or tax nr returns nothing.
I can change the column to CustomerName (and add the others as additional); then they can search for the name but not the id or the tax nr.
Any idea how can I make search work for all the columns of the list?
My scenario is:
- I have created a list, let's call it Customers, with a few columns, say CustomerID, CustomerName and CustomerTaxNr.
- Then there's the Document Library in which I've created a column of type Lookup, getting data from the Customers list. It shows one of the fields, say CustomerID, and I've done the "add additional columns from the list" to show the rest of the fields.
So far so good. Every document in the library is tagged with a CustomerID and shows the CustomerName and CustomerTaxNr as well.
But then we get to search.
With this configuration, users can search for CustomerID and find the relevant documents. But searching for customer name or tax nr returns nothing.
I can change the column to CustomerName (and add the others as additional); then they can search for the name but not the id or the tax nr.
Any idea how can I make search work for all the columns of the list?
Share Improve this question edited Mar 31 at 9:03 jonrsharpe 122k30 gold badges268 silver badges475 bronze badges asked Mar 31 at 9:01 Jim AndrakakisJim Andrakakis 1872 gold badges3 silver badges10 bronze badges1 Answer
Reset to default 0Ok, answer was given in MS forums:
Manually add index: Go to library settings > Indexed columns > Manually add the lookup column, then
Go to Site settings > site information > view all site settings > Search and Offline Availability > Reindex the site.
After reindexing (which can take some time, depending on volume) search works.