All geek questions in one place

How to enable a view in SharePoint2010, where more than 8 Lookup columns can be present?

I have a SharePoint2010 list that contains about 15 search columns. I created a view in which all 15 are present. When I try to open this view, I get the following message:

This view cannot be displayed because the number of search queries and the workflow status columns that it contains exceeds the threshold value (8), administrator.

Is there a way to remove or change this restriction? Thank you

+4
source share
3 answers

I found that this restriction is not a restriction, but a setting - and it can be changed! Go to Central Administration and then go to:

  • Application Management> Web Application Management.
  • In the list of web applications, select the desired web application.
  • Then go to General Settings> Resource Throttling.
  • In the Resource Management window, scroll down to Attempt to View List and change the value to a number that matches your needs.

Of course, increasing this value affects performance because there is more drilling through SQL tables, so be careful not to go too far. And one more thing: changing this value affects not only the list views, but also changes the behavior of methods that work with list items. For instance. if this parameter is set to 8, this will return a maximum of 8 search fields for the list item when GetListItems (request); (Customer Object Model). Increasing this number, say 15, will increase the maximum number of returned search fields for a list item. Pretty neat!

+8
source

You are right, Boris. Although that’s all, keep in mind that this setting cannot be changed in SharePoint 365 / Online.

0
source

True Boris, but keep in mind that increasing this threshold will greatly affect performance.

Please check this article from MSDN

0
source

Source: https://habr.com/ru/post/1308339/

More articles:


All Articles