Hi All,
I have a scenario to get filtered data from one list which has around 50,000 items.
Scenario 1:
I have a list having 50,000 items (without folder structure). When I query the list I got listview threshold exceed exception when result set is greater than 5000. I also indexed the fields in which I am filtering the data.
Scenario 2 :
I created another list and stored 50,000 list items in 5 folders (10,000 list items in each folder). When I query folders of this list, I got all the filtered data which are greater than listview threshold without exception.
Note :
1) The user has only read permission in site.
2) Threshold limit is 5000 for normal user and 20,000 for administrator.
3) Not using “SPQueryThrottleOption.Override” property.
I am amaze why I am not getting listview threshold exceed exception when result set scanned by query in any folder is greater than threshold limit.
The source code is attached for getting data from list folder’s.
I need help in this case.
Regards,
Sanjay
Hi,
I cannot adjust the default listview threshold for normal users.
When I am querying the list (without folders) with more than 50,000 records than if row scanning is greater than 5000 then I am getting threshold exceeds error.
When I am querying the folder of list (each folder contains more than 5000 items) and if result set is greater than 5000 then it is returning the result without any threshold error.
But when I am accessing that folder from GUI then it is showing the threshold exceed exception for the same user.
I am not sure whether this is a bug in Sharepoint 2013.
Regards,
Sanjay
