I have a SharePoint List with over 5000 records created by me. The below query when using ID in filter works. But when I Filter With CreatedBy me it gives me List View Threshold Error.
_api/Web/Lists/GetByTitle('TestRecords')/Items?$select=ID,Title&$filter=Author/EMail eq 'firstname.lastname@example.org'
_api/Web/Lists/GetByTitle('TestRecords')/Items?$select=ID,Title&$filter=ID gt '5'
Both the above query returns more than 5000 records. But when using ID it works and gives 100 records. When filtering with Author it gives threshold error. I even indexed the CreatedBy Column and it still gives Threshold error. Why does it not return only 100 records?