A separate group of IT personnel own the farm on which they are migrating from SharePoint 2007 to 2010. I have a production site that I have been building for the last two years. In particular, there is one list that has approximately 7,900 records already in the list. The list view threshold is set to the default of 5,000. I have done about three weeks of reading on anything Microsoft in effort to resolve this issue. I have attempted to execute every recommendation that I have extracted from this research. These executions include:
creating a new list view complete with filter(s) to reduce the results to way less than 5,000. While the .aspx page will return the desired results, the minute I bring the list into a web part on a page and redirect the web part view to the new list view, that damnedable threshold error message is ALWAYS the result.
creating an indexed column - I have gone through the list settings, click on the Indexed Columns-->create a new index-->set the primary index with no secondary-->clicked the create button. RESULT: that damnedable threshold error message.
created a query that resulted in that damnedable threshold error message.
Since I don't own the farm, I cannot do anything at the farm level. The only other tool available to me is SharePoint Designer 2010.
Is there ANYone out there that can provide a real answer to this problem?
(I gotta tell ya Microsoft, I understand why you incorporated the threshold, but I think it is one of your dumber ideas if the error is thrown because the query has to sort through more than 5000 records. What is the point of having the ability to have a large list if everything one does throws that damnedable threshold error message???) Yes, I am MORE than frustrated!!!