98 reputation
18
bio website brad-smith.info
location Perth, Australia
age 28
visits member for 2 years, 8 months
seen Jun 28 '13 at 3:55

Hi there! I’m a software engineer from Perth, Western Australia. I was born in 1985 and I have 5 years of commercial software development experience. I mainly focus on desktop applications and database-driven business systems, but I have developed the odd web application, web service and even a few games in my youth. While my academic background is in Java and C++, most of my commercial experience is in C#. I occasionally delve into PHP and other languages when it suits a particular project.


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