您的查询返回的结果数量大于Web应用程序的查询限制限制。请调整此Web部件的配置或增加限制限制。 [英] Your query returned a greater number of results than the web application's query throttling limit. Please adjust the configuration of this Web Part or increase the throttling limit.

问题描述

大家好，



我有一个要求显示来自我创建的SharePointonline文档库文档。



所以，我在页面上添加内容查询Web部件并在下面的图像上显示配置



步骤： - 编辑内容查询Web部件和其他过滤器：< b> Create By等于我或由[_Hidden]修改等于我。



但显示错误



您的查询返回的结果数量大于Web应用程序的查询限制限制。请调整此Web部件的配置或增加限制限制





谢谢

Akash Anand

Hi All,

I have a requirement display Document from SharePointonline Document Library that is Create by me.

So, I Add Content Query Web Part on Page and Configure as show on below image

Steps:- Edit Content Query Web Part and Additional Filters: Create By is equal to Me or Modified by [_Hidden] is Equal to Me.

But Display Error

Your query returned a greater number of results than the web application's query throttling limit. Please adjust the configuration of this Web Part or increase the throttling limit


Thanks
Akash Anand

推荐答案

通常，当列表达到阈值限制（默认为5K）时会发生错误。



您可以随时增加特定列表的限制限制。



HTTP：//blogs.msdn。 com / b / dinaayoub / archive / 2010/04/22 / sharepoint-2010-how-to-change-the-list-view-threshold.aspx [ ^ ]



但是，我不会建议，而是寻找添加更多适用的过滤器，你可以使用。



如果你不能改变规则，你必须遵守。因此，如果您无法更改限制限制，则应应用过滤器。例如。 30天批量获得结果

Generally the error occurs when the list has reached the threshold limit (5K by default).

You can always increase the throttling limit for a particular list.

http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx[^]

However, I would not advice that and instead look to add more applicable filters which you can use.

If you cannot bend the rule, you have to abide. So if you cannot change the throttling limit, you should apply filters. E.g. get results in batches of 30 days

Hi Manas，



感谢您的回复。但我对SharePoint Online / Office 365网站的要求。



请建议任何适当的方式..







谢谢

Akash Anand

Hi Manas,

Thanks for replying. But my requirement for SharePoint Online/Office 365 site.

Please Suggest any appropriate way..



Thanks
Akash Anand

SharePoint在线有很多limitations 。如果它是SharePoint内部部署，那么Manaj给出的解决方案是正确的。



对于SharePoint Online，您需要一些解决方法，如> 。

另请参阅螺纹。它与我们在这里讨论的问题相同。

SharePoint online has lot of limitations. If it was SharePoint on premise, then the solution given by Manaj is right.

For SharePoint Online you need to some workaround as explained here.
Also refer this thread. It has the same issue what we are discussing here.

这篇关于您的查询返回的结果数量大于Web应用程序的查询限制限制。请调整此Web部件的配置或增加限制限制。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！