SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list over 200,000 items in it. It's on normal threshold (2,000 items per view). Users want large threshold but there is price for that. SQL traveling/transaction, server overhead and the whole nine yard.

Is there a codeplex or custom filter option webpart that can be place in the list view page so that users can use the custom filter to type in whatever they are looking for instead of list's built in filter options?

I hope I am making sense.

share|improve this question

Sounds like search might be a good option. Maybe create a special search page (could be the view page) where you:

  • Add a search box
  • Add a core results web part where you:
    • set site:UrlOfList as additional query parameters
    • set xslt to render with the information you want

And then teach users about Keyword query syntax

share|improve this answer

For that, I'd say create a view with the desired columns then use the Export to Spreadsheet option. Save the IQY file generated to a Document library or a datasource library and point the user to it. They can then open that in Excel and do all the filtering on their local machine and not pound the server.

The opening of the IQY file will pull down all the data, regardless of what the list view paging options are set at.

Or the user could open Access and pull down a copy of the list and query it that way. I prefer the Excel option personally.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.