I am facing this strange and UN-logical behavior inside our custom list view. now we have a sharepoint enterprise farm 2013. and the list threshold for the web application is set to the defualt which is 5,000. but i am facing this scenario:-
- I have added the "Created By" column inside the Index columns for the custom list.
- I defined a list view which will show items that were created by the "System Account" and sort items using the Id, as follow:-
- then using the site admin, i accessed the list view and i can view all items which equal to 2949, as follow :-
4. so now since i am filtering using an Indexed column (Created By) + i am sorting using the ID + the total number of items = 2949, so i were assuming that end users will be able to access the list view, but when they do so they got threshold exception, as follow:-
So can anyone advice on this please?
and the number of items on the view will be equal to 350, and end users were able to access this list view.. so is the issue i am facing on my first list view is with the Indexed column (created-by) OR the problem with the number of item which is 2949, although it is below the threshold which is 5,000??