We have migrated from SharePoint 2010 to SharePoint 2013. I see that we have a few lists migrated from 2010 to 2013 where views work perfectly fine in 2010 but we get the threshold error in 2013 environment. We have the same Threshold values for both the environments.

I am not sure what is causing the issue in 2013.

  • what error you are getting? could you please share? – Waqas Sarwar MVP May 10 '16 at 14:48
  • What is the threshold and how many items do you have? – Ramana Viswanadha May 10 '16 at 14:50
  • 1
    Check your list to see if the indexed columns exist, if not, create indexes on the desired columns – Eric Alexander May 10 '16 at 15:07

The List View Threshold applies when a List query attempts to retrieve a number of items greater than the Threshold. If you're receiving an error, that's the most likely cause.

Some things to check:

  • Sorting: You cannot apply a sort using a column that is not indexed. If you have sorting applied to the views, ensure you're using only indexed columns.

  • Item Limit: If no filters are applied and you select "Display items in batches", the query will fail. On the other hand, you can use "Limit the total number of items" selection to satisfy the threshold.

  • Filters: The columns you select for filtering must also be indexed, and you're limited to using 'AND' for multiple filters; 'OR' will retrieve all items before filters are applied.

I did some quick testing on the filters and it seems pretty inconsistent. I have a list with a number field and applied a filter to get values over 20000 (0 items) OR items less than 5000 (<5000 items). That query failed. However when I did greater than 15000 OR less than 100, I get items in the 5000 range, which makes no sense at all.

If you're not using sorting or it's configured correctly, I'll bet dollars to Timbits it's your filtering. I'm not sure exactly how things have changed from 2010 to 2013, but I know the 2013 List View Threshold is extremely rigid so I suggest you start there.

|improve this answer|||||

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.