sharepoint2010:The number of items in this list exceeds the list view threshold, which is 20000 item...-优快云博客

本文介绍了解决SharePoint中ListView超过20,000项阈值限制的方法，包括建立索引、增加阈值及设置过滤视图等手段。当这些方法效果不明显时，提出了一种导出列表再进行清理的解决方案。

ist view threshold :

107806 items (list view threshold is 20000).

The number of items in this list exceeds the list view threshold, which is 20000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.

Learn about managing a large list or library and ensuring that items display quickly.

sharepoint2010:找了N多方法，建INDEX,增大threshold，设置FILTER VIEW等。

效果都不明显，

那只好导出LIST，然后删除无用的LIST这方法了。

在SQL里搜索相应的LIST，并导出为EXCEL供审核。

~~~~~~~

测试语句，至于如何获得tp_ParentId号，新建一个LIST，自然可以知道。所有数据都在AllUserData表里。所以要查询。

1 select top 50 tp_Created,nvarchar1,nvarchar4 from AllUserData where tp_ParentId='A4CCCB83-FA83-4558-A88C-F919B6606699' order by tp_Modified desc

查询结果和导出操作截图如下：

转载于:https://www.cnblogs.com/aguncn/archive/2013/03/06/2945476.html