问题描述
在SharePoint在线中,我有一个包含12000个项目的列表。
In SharePoint online, I have a list with 12000 items.
我有一个视图设置为过滤3个不同人员字段等于的项目[我]鸟Field1等于[Me]或Field2等于[me]或field3等于[Me]。
I have a view that is set to filter for items where 3 different people fields are equal to [Me]. Field1 equal [Me] or Field2 equal to [me] or field3 is equal to [Me].
在此列表中,没有我在任何字段中的项目。  ;所以结果是0. 如果我有视图转到列表视图,它可以工作,但如果它是一个快速编辑视图,我会收到有关超过5000项视图的消息。
In this list, there are no items where I am in any of the fields. So the results are 0. If I have the view go to list view, it works but if it is a quick edit view, I get the message about views over 5000 items.
它似乎也有所不同在条件上。 如果我只按其中一个字段进行过滤,则可以在列表视图中进行快速编辑。 一旦我添加了OR,我就会遇到问题。
It also seems to vary based on the conditions. If I filter by only one of the fields, it works in list view and quick edit. Once I add a OR is where I have the issue.
对于大型列表上的快速编辑,可以使用过滤条件的数量有限制吗?
Is there a limit on the number of filter conditions you can have for quick edits on a large list?
thans
推荐答案
不同的过滤条件会使查询的复杂性不同。
Different filter conditions make the query complexity different.
过滤条件越多,越多复杂的查询是。
The more filter conditions, the more complex the query is.
这篇关于快速编辑视图和大列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!