Forum Discussion
Peter Mcdermott
Mar 08, 2018Iron Contributor
Searching for Items in SharePoint Lists with over 5000 Items
It is my understanding that indexing a column and restricting a view to have less than 5,000 items will make work of lists with over 5,000 items. However, how does searching work? If my view only has...
Dean_Gross
Mar 11, 2018Silver Contributor
have you added indexes to the list? the new intelligent indexing feature eliminates a lot of the historical problems with large lists, BUT, you need to add at least one index before you get to 20,000 items and preferably before 5,000
Have you looked into using managed metadata navigation to easily filter a very large data set like you describe.
Peter Mcdermott
Mar 11, 2018Iron Contributor
Dean, I've added indices, however if I limit a view, I can't search beyond that view. I feel like I'm stuck.
- Dean_GrossMar 11, 2018Silver Contributor
I assume that your list in Classic view and that you're using the native search box on the page and that our results are getting returned on the default osssearchresults.aspx search results page. Is this the case?
- Peter McdermottMar 11, 2018Iron Contributor
Dean, I'm using modern pages.