Reputation
Next privilege 125 Rep.
Vote down
Badges
1 8
Impact
~9k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Mar
21
comment “View exceeds list view threshold” even when it doesn't
I was uncomfortable disabling throttling completely, so I decided to change my strategy; instead of using a view, I now use a CAML query executed using the object model. The query runs with the SPQueryThrottleOption.Override setting, thus bypassing the list view threshold. I haven't tried your solution, but the only difference between it and others i've tried is that you're adding the condition 'ID>0' - i'm not sure why this would fix the problem?
Jan
24
awarded  Notable Question
Aug
31
awarded  Commentator
Aug
31
comment What permissions are required to access SPSite.Usage?
Although called View Usage Data in the documentation, the actual permission is called View Web Analytics Data. Unfortunately, turning this on does not give the user permission to the SPSite.Usage property via the object model. It seems to be concerned more with usage reports than the raw data.
Aug
31
asked What permissions are required to access SPSite.Usage?
Aug
6
awarded  Benefactor
Aug
6
awarded  Scholar
Aug
6
accepted “View exceeds list view threshold” even when it doesn't
Aug
6
comment “View exceeds list view threshold” even when it doesn't
Yes, the total count equals the number of items returned by the view.
Aug
5
comment “View exceeds list view threshold” even when it doesn't
@PirateEric No, there are none; the library matches the default settings.
Aug
2
comment “View exceeds list view threshold” even when it doesn't
The view returns 129 checked-out documents. The list contains 52,583 documents, arranged into folders so that no folder contains more than 2000 documents. I get the list view threshold error on the view when the threshold is set to 5000, but not when it is set to 20000.
Aug
1
comment “View exceeds list view threshold” even when it doesn't
Unfortunately this still doesn't explain why, even after creating an index on the Checked Out To field (and filtering using a not-equal-to condition), I continue to receive the list view threshold error.
Jul
31
comment “View exceeds list view threshold” even when it doesn't
It's helpful to know that the throttling can be switched off entirely, but it's an undesirable solution. I am more interested as to why i'm running into the problem in the first place (no folder contains more than 2000 items), and why indexing the view doesn't solve the problem.
Jul
31
comment “View exceeds list view threshold” even when it doesn't
I raised the throttling threshold from 5000 to 20000, but I don't regard that as an acceptable solution.
Jul
30
awarded  Promoter
Jul
26
awarded  Popular Question
Oct
27
comment “View exceeds list view threshold” even when it doesn't
Edit: Some theories as to why this may not be working: 'Not equal to' is not a SARG, so it may not get optimised properly? Recursing through all folders is preventing the view from being optimised?
Oct
26
awarded  Student
Oct
26
comment “View exceeds list view threshold” even when it doesn't
I deleted the existing view, created an index on 'checked out to' and recreated the view. 'Checked out to' was displaying as indexed, as expected. After saving the view, I got the same error message when I tried to open it. Could this have anything to do with my filter being based on a 'not equal to' condition, or the fact that this is SharePoint Foundation?
Oct
26
asked “View exceeds list view threshold” even when it doesn't