Disable list view threshold for particular List

There can be situations where you want to use large list that has more than 5000 items. When querying the list you are getting the error of list view threshold on filtering or when querying items from forms.

Capture

The query cannot be run for the following DataObject: ComputerList1
The SOAP response indicates that an error occurred on the server:

Exception of type ‘Microsoft.SharePoint.SoapServer.SoapServerException’ was thrown.
<detail><errorstring xmlns=”http://schemas.microsoft.com/sharepoint/soap/”>The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.</errorstring><errorcode xmlns=”http://schemas.microsoft.com/sharepoint/soap/”>0x80070024</errorcode></detail&gt;

Capture

You have the option to remove the List view threshold from the whole web-application by going to Central administration –> Manage Web applications –> Highlight the Webapp

Go to General Settings –> Resource Throttling –> modify the List view threshold.

Capture

But you don’t want to alter the global settings of web application & just want to be alter the settings for this particular list as you are sure there would be No performance impact as it would be rarely used, Changing globally is not a good idea as per our research.

So here is what you can do, open share point management shell with the farm account & run the below code.

$WebApplication = Get-SPWeb “http://sharepoint/sites/Site&#8221;
$List = $WebApplication.Lists[“ListName”]
$List.EnableThrottling = $true
$List.Update()

This will disable the List View threshold for this particular list.

Bingo-Ok-Okay-Superman-Sure-You-Got-It-GIF-2015

Regards

Sukhija Vikas

http://msexchange.me

 

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s