There is a document library which has over 5000 items, it has passed its item view threshold. The view was reduced to show items that met certain requirements. This view now shows less than 1000 records.
When some users use the the column name to filter they receive a message “Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator.”
The threshold item view limit is in the Central Administration but this is not something that we want to change because of performance reasons, so this would be a last option for this. Some of the columns the view is filtered by are indexed, as this was a suggestion.
The way I see it is that it should be working properly. The view is within the threshold limit so it should not have an issue. All users were able to use it properly before it reached 5000 items. This error shows for some users but not all.
Is there something else that should be done to allow all users to have access to filter the view by using the column name?
UPDATE: The list view currently has 3 filters on one column. The column is a choice and is indexed.
The filters are as follows:
column1(Indexed) is equal to value1
column1(Indexed) is equal to value2
column1(Indexed) is equal to value3
When I remove one of the filters it works fine, it does not matter which of the filters I remove. Filter_1 return 2880 items, Filter_2 return 17 items, and Filter_3 returns 97 items. For a total of 2994 items returned.
Would there be a restriction on having multiple “Or” filter statements on the column?