Is it possible to display the most recent 5,000 items in a list using the ID ? If the answer is yes, then how ? Also, is the ID inherently have an index ?
I noticed when I tried to create an Index on ID it was not an available field.
Add a comment
|
3 Answers
if the concern is just to get the most recent items, get it on the basis of Created date.
5000 is the list item limit for a view, or as Microsoft puts it, "approximately 5000". (Source) So in theory the number is achievable.
ID has an incremental number as its value, but it is not available as a column to be shown. If you want to use it, you may achieve it by creating a calculated column which uses the value of [ID]. Bear in mind, that when a list item is removed, its index value becomes empty.
-
If I create a calculated column then how do I view the most recent 5,000 Nov 30, 2017 at 3:27
-
@daPlayaURH The item limit for a view is defines in the list's view settings. Adjust the item limit -setting according to your needs.– moeNov 30, 2017 at 8:04
You may want to make a view that shows items sorted by Created or Modified date to see the recent items in the list according to that. I wouldn't rely on ID's alone because they increase as time goes by but don't get replaced or re-used when users delete items in the list.
According to this the built in ID column is already indexed as it is a system field(column). https://msdn.microsoft.com/en-us/library/ff798465.aspx
-
But if I sort on Created date and it gets beyond 5,000 I will not be able to view the list ? What am I missing ? thx Nov 30, 2017 at 3:27
-
dealing with larges lists that exceed 5000 doesn't matter what you sort by. its a combination of using column indexing, using filers, and folders is what helps you overcome this. There are several articles on the web that talk about the 5000 view limit. See this slide deck for more: slideshare.net/gzelfond/…– Chris GNov 30, 2017 at 14:37