I've got a list with ~10k items in it; I've indexed this on a number of columns and have recently started to see 500 errors when querying the list via REST ($.ajax) despite the queries previously returning 5k+ rows with no issues.
I appreciate questions in a similar vein are asked quite a lot but I've not seen anything that quite hits what I'm looking for.
If I run this:
Data is returned with no issues.
However if I run:
https://mysite/_api/web/lists/getbytitle('myData')/Items?$select=*&$filter=(DateReceived ge datetime'2018-04-01T00:00:00.000Z') and (DateReceived le datetime'2018-11-30T23:59:59.999Z')
I get a 500 error.
'DateReceived' is an indexed column and I've looked at the raw data, whilst there are over 5000 entries in the 'DateReceived' field; there's only ~200 unique entries.
There are some additional columns involved in the filtering and sort but all of these are indexed.
I've never come across this before, I have plenty of other lists well above the 5k limit that are all similarly indexed and no trouble there; part of me wants to delete the indexes and re-apply but wondering if there's something I'm missing here?
I have a large list with indexed columns but when I filter the list via REST, on an indexed column, I get 500 errors. I can however do a select * and return all data with no issues.