4

I have custom list with 9000 items. I created index column on AccountNo and created a view with Filter (AccountNo equal 2090) and it should return 36 records. However, I am getting following error

This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.

  • are you sure that AccountNo equal 2090 should return only 36 items? – Atish Dipongkor - MVP Oct 30 '15 at 15:21
3

I fixed the issue by deleting the trouble Indexed column. I have no idea why AccountNo column would index from UI but i ran a powershell and it would throw an error "Cannot get property value because "Indexed" is a write-only property.". Luckily I had a another column indexed which I used to create view with filter and threshold error went away.

1

This message appears when a SharePoint list gets large (>5000 items). The default list view threshold for any SharePoint list is 5000. Once this threshold is crossed the list becomes slow and many features of the list does not work.

The only work around you can do now is to increase the threshold. This can be done at web application level in central administration. See this post on increasing list view threshold.

While the damage has already been done, it is not a good approach to increase the list view threshold. SharePoint can support around 30,000,000 items in each list.But in a single view it can support only 5000 items by default. It is always to prepare and plan in advance for the large lists. See this blog on designing large lists in SharePoint.

  • good post but that does not solve my problem. I index a column and create a filter view based on the index column. It should now return 36 records but it doesnt. May be the index is not going through. Any thoughts? – Kevin Short Oct 30 '15 at 15:33
  • 1
    The threshold is not the number of items returned , it is for the number of items the query is being performed on, in this case the query is performed on 9000 items – Unnie Oct 30 '15 at 15:35
  • 1
    Also check whether Recycle bin does not have more items for the Account No – Unnie Oct 30 '15 at 15:42
  • Recycle bin is clear. – Kevin Short Oct 30 '15 at 16:19
  • Increasing the treshold is NOT the only work around. Using indexed columns is possible in such case and should do the trick. When creating a view it is important that the first filter is using the indexed column. And when this first filter is applied the query must not return more items than supported by the threshold. see this support article for more details – DonKristo Nov 7 '15 at 12:36
0

Although Lookup column is available to indexing and filtering however it does not solve the issue with creating filter based view. I re-created a view that gives me same result instead of using AccountNo (which is lookup column and indexed). The error went away. so I think it's a bug which needs to be reported to Microsoft.

  • did you make sure that the AccountNo filter is the first filter criteria you set? that is required in order to bypass the threshold. – DonKristo Nov 7 '15 at 12:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.