筛选器在大列表的数据表视图中不起作用(超过5000个项目) [英] Filter not working in datasheet view in large lists(over 5000 items)

问题描述

我们有一些列表包含5000多个项目，并且在使用数据表视图时，我们发现过滤在那些列表中不起作用.尝试对列进行索引以及对特定列表禁用列表视图限制，但无法获取过滤器 在职的.如果项目计数超过5000，这是SharePoint中的预期产品行为吗?

We have some lists which are having more than 5000 items and we see that the filtering is not working in those when using the datasheet view. Tried column indexing along with disabling list view throttling for the specific list but could not get the filter working. Is it a a expected product behavior in SharePoint in case of item count going beyond 5000 ?

推荐答案

您的意思是过滤器"是列标题过滤器?如果是，请检查以下线程:

Do you mean the "filter" is column header filter? If yes, please check the thread below:

您还可以尝试将列表视图阈值增加到管理中心列表中的项目数量以上.并启用大型查询的每日时间窗口".

And you can also try to increase the list view threshold to more than number of items you have in the list in Central Administration. And enable "Daily Time Window for Large Queries".

最好的问候，

丹尼斯

这篇关于筛选器在大列表的数据表视图中不起作用(超过5000个项目)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！