SharePoint4us

Hi friends,

Thanks for visiting my blog .

In this post, i would like to describe about "Disable throttling of List in SharePoint".

Scenario : 
I came across a situation where i want to fetch the list items  from list (consists of more than 2 lakhs).

Problem :
 when am pulling the items from the list it showing an error saying that you cannot pull items from list as it exceeds list threshold limit (by default 5000 in central administration  we can see the limit and increase but increasing here is not a good practice ).

Solution : 
we can disable  throttling limit  for particular list in which you want to query the items.
we can do this  by using powershell and object model to my knowledge.


PowerShell Script :
****************************
$web = Get-SPWeb "Site Url"
$list = $web.Lists["ListUrl"]
$list.EnableThrottling = $false
****************************

Paste in notepad and save as ".ps1 " .
1.Open the Management Powershell command prompt (run as administrator).
                 2. Execute the .ps1 file here.
                 3. Go back to the logic and try to query the list items .


Thank you hope this post helps you in understanding 

Hi Friends,

In this post , I would like to tell you very simple tip to find out the GUID for  SharePoint List .

Scenario :
I came across a situation where i want to use a GUID of SharePoint List in my coding .

How to get GUID for SharePoint List  ?

Step 1:

Select the list for which you want to know the GUID .

GOTO-->List Settings

 Step 2: 

       Under General Setting -->Select any of the available links.
      Am selecting  Audience targeting settings Link.

     --> Right Click -->Copy Shortcut -->Paste in  notepad



 
Note :
These techniques work for SharePoint 2010 Standard/Enterprise editions as well.This  tip does not work for SharePoint 2010 Foundation as these list settings options are not available 

so you’ll need to do  the following 

• Navigate to the SharePoint list using the browser.
• Select the Settings + List Settings menu command.
• Copy the URL from the browser address bar into Notepad. It will look something like:

http://moss2013/ProjectX/_layouts/listedit.aspx?List=%7B26534EF9%2DAB3A%2D46E0%2DAE56%2DEFF168BE562F%7D

• Delete everything before and including “List=”.
• Change “%7B” to “{”
• Change all “%2D” to “-“
• Change “%7D” to “}”

You are now left with the Id:
{26534EF9-AB3A-46E0-AE56-EFF168BE562F}.


These are the ways to know the GUID for List.

Hope its helpful....:-)