I have a list with 20,000 records that I have been trying to deal with. Threshold is at the default 5k.
I was under the impression that if I index a column, filter on it, and my results are under 5k, I should be able to see everything. I have an indexed "status" column. I have 51 records with status pending. My filter says show only items when status = pending.
On my view I'm getting the dreaded "Displaying only the newest results below. To view all results, narrow your query by adding a filter." And I see 2 results.
If I login under admin account (with it's higher threshold), I correctly see 51 results.
What am I missing?