While working with SharePoint custom coding on lists, I got
an error saying that “This view cannot be displayed because the number of
lookup and workflow status columns it contains exceeds the threshold..”
After googling in to the issue, I have found the solution in
this post. We can see this problem due to lookup columns value exceeds the
SharePoint environment configuration value. When tis error occurs, SharePoint web
services will refuse to return the documents. By increasing “List View Lookup
Threshold” value, we can fix this error.
We can increase the limit in SharePoint central
Administration by using following steps,
Navigate to application Management in SharePoint Central
Administration and click on “Manage Web Applications” link.
Select the web application to increase threshold value,
Click on “Resource Throttling” in General Application Settings in the ribbon.
In List View Lookup Threshold” section we can specify the
maximum number of lookup that Specify the maximum number of Lookup,
Person/Group, or workflow status fields that a database query can involve at
one time. Change the value to bigger and click on OK to save the settings.
Share this
