I’ve an inventory with 7000+ objects on a SP 2016 surroundings that has the default threshold of 5000 objects. I created an OOB listview filtered on “ID is lower than 2500”. This view comprises 5 columns (all listed), has no sorting, grouping, or totals, and is paged in batches of 30. The view shows simply high-quality.
Nonetheless, after I pull down the column head dropdown menu, choose one filter worth, shut the dropdown after which return to that dropdown, the next error seems.
Can’t present the worth of the filter. The sphere is probably not filterable, or the variety of objects returned exceeds the listing view threshold enforced by the administrator.
After I click on OK, the filter dropdown solely shows ‘Clear Filters on [this column]’, not the precise filter values.
After I filter out one worth, then attempt to filter one worth in one other column, the filtering shouldn’t be utilized till I unfilter the primary column.
If I choose a couple of filter worth to begin with, every part works high-quality (i.e. I can return to the dropdown and/or add filtering to different columns).
Any concepts on why this occurs or higher, the right way to clear up this?