SharePoint List not showing all items '

Question

_{Monday, July 20, 2015 9:46 AM}

We have SharePoint 2010 environment containing one list with 11000+ items when seen from 'View All Site Content'.

But, it only has 1250 items in it overall as checked.

Even 'All Items' View has not been filtered with any conditions. It has been set to show all items.

Even filter results are showing items from that 1250 items.

But, when filtered through Key Filter, results from 11000+ items are shown.

Why is list not showing all items?'

- Suyog Patil

All replies (8)

_{Monday, July 20, 2015 12:30 PM ✅Answered | 1 vote}

That's a standard behaviour, if you have indexes set and the views have the right ordering process then the view will do a 'best effort' for the items it brings back.

Views are quite complicated at the point when they cross the limit but there's a good article here: https://support.office.com/en-za/article/Manage-lists-and-libraries-with-many-items-11ecc804-2284-4978-8273-4842471fafb7#__toc264017710

On the other hand i'm not sure it's relevant.

_{Monday, July 20, 2015 10:08 AM}

I can't remember if version history or deleted items shows up in the View all site content pane, but the best way to tell how many items there are in the list is to use PowerShell to get the list object, then use the .ItemCount method.

_{Monday, July 20, 2015 11:17 AM}

Item count : 11719 '
So, it is clear that version history or deleted items are not shown in 'View All Site Content Count'

- Suyog Patil

_{Monday, July 20, 2015 11:41 AM}

what is the List View Threshold that is defined in your env?

here you have some info regarding List View Threshold in case you want to change it

http://www.sharepointboco.com/performance-with-sharepoint-2010-large-lists-list-view-throttling/

MCITP|MCTS SharePoint| SharePoint Performance blog

_{Monday, July 20, 2015 12:27 PM}

Bogdan, threshold limit set on SharePoint Envronment is 5000 and performance is not an issue.

So, do you say that, since, list has crossed threshold limit, few items in list are not being shown?'

If you could find some article to support your answer...'

- Suyog Patil

_{Monday, July 20, 2015 1:10 PM}

Even after creating view, items from those 1250 items are only filtered out.

Rest items cannot be seen, inspite of being present.

Also, when exported to excel, all 11000+ items can be exported.

So, shall it be concluded, this behavior is due to crossing threshold threshold limit?

- Suyog Patil

_{Friday, April 15, 2016 2:51 PM}

Even I am facing the same issue in SP2013 environment, Is there any solution to refresh the List view item count , Or simply make $list.itemcount = List view threshold value?
Please suggest how to make list item count value equal to List view threshold value.

_{Monday, April 18, 2016 11:08 AM}

You're asking the wrong question. The threshold is set to prevent that from happening, unless you know exactly why that is the case and you know the implications of violating that safety measure you shouldn't be turning it off.

Start a new thread describing what your list needs to do and explaining how the threshold is limiting you.