I try to prepare a view for a list containing more than 5k items. When I try to filter it by an equal value in one column via REST API /Items?$filter=Status eq 'Not completed' , it does show a list of items in the response.

I understand that it is successful because the number of the items after filtering is lesser than 5. However, I then try to apply another filter:

/Items?$filter=StatusChangeDate gt datetime'2022-03-01T11:38:55Z'

I receive the error The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. It seems strange because the number of the items after applying the filter should definitely not exceed 5k. It is as if for the date the server regarded the number of items before filtering, not after. But if that is so, I do not understand why it does work with the first filter.

What could be the reason behind those filters being treated differently and is there any other way to apply filtering by date and not exceed this threshold?

  • Do you have a column index on the StatusChangeDate column?
    – Greg W
    Mar 2, 2022 at 10:16

2 Answers 2


I don't see where can be the problem, why don't you append the Filter into one expression !

like this :

/Items?$filter=(Status eq 'Not completed') and (StatusChangeDate gt datetime'2022-03-01T11:38:55Z')

This should work perfectly !!

  • The problem is that I need to go through various statuses. For some of them, like: "$filter=(Status eq 'Not completed') and (StatusChangeDate gt datetime'2022-03-01T11:38:55Z')" it does work, bot for other statuses (more frequent ones) it does not. The same happens when I combine them with OR like: "$filter=((Status eq 'Not completed') or (Status eq 'Approved')) and (StatusChangeDate gt datetime'2022-03-01T11:38:55Z')"
    – Jacek
    Mar 2, 2022 at 10:00
  • This should be like this : $filter=(Status eq 'Not completed' or Status eq 'Approved') and (StatusChangeDate gt datetime'2022-03-01T11:38:55Z') Mar 2, 2022 at 12:17
  • Unfortunately, it still does not work
    – Jacek
    Mar 2, 2022 at 13:31
  • can you put the whole query here !. Mar 3, 2022 at 7:51

I know this is kinda late but is it helps anyone. I found the solution as to index the column on SharePoint. Because the column is indexed it doesn't need to load all the rows first.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.