I am querying list using REST.
API: siteURL = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('Test')/items?$top=5000&$filter=((BBEmail eq '"+_spPageContextInfo.userLoginName+"')or(OpexCatalystEmail eq '"+_spPageContextInfo.userLoginName+"')or(PEGLeadEmail eq '"+_spPageContextInfo.userLoginName+"'))&$orderby=Modified desc";
The fields below are indexed.
- BBEmail
- PEGLeadEmail
- OpexCatalystEmail
- Modified
Still getting the threshold error when hitting the api.
{"readyState":4,"responseText":"{\"error\":{\"code\":\"-2147024860, Microsoft.SharePoint.SPQueryThrottledException\",\"message\":{\"lang\":\"en-US\",\"value\":\"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.\"}}}","responseJSON":{"error":{"code":"-2147024860, Microsoft.SharePoint.SPQueryThrottledException","message":{"lang":"en-US","value":"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."}}},"status":500,"statusText":"error"}