I am getting list view threshold although all the columns involved in the filter and Sort are indexed columns

Question

I have the Workflow tasks list which contain 42,613 items. and inside a list view i have those filtering and sorting (where all the columns are indexed):

But when we access the list view we got this threshold error:

Although those columns involved in the filter and sort are indexed as follow:

And the Item count is set to 50, as follow:

Any advice on this please? how we can overcome the threshold error?

Answer 1

This is a known issue with SharePoint list view filters and SharePoint REST APIs filters.

If the filter query (or first part of filter query) returns more than 5000 items it will throw an error.

This will not work even if you are indexing the columns. Try using the filter query where the number of items returned by the first part of filter query will be less than 5000.

Similar thread: SharePoint REST limitation?

Answer 2

Do you have more than 5000 items that are newer than 165 days? I believe the filters applied in the query are evaluated in the order you specified them and if your first condition exceeds 5000 items the other conditions will not be evaluated anymore because that would exceed the threshold. Although you only might have a very small number of actual items meeting all criteria. I only encountered this with "equals"-conditions, so the "greater than" and "begins with" conditions might complicate this even further.