To all SharePoint folks,
Have anyone noticed, when we apply OR operator in REST API filter having more than 5000 List items, it will throw error code 500 even if I return single item.
FYI, All columns are indexed.
site/_api/web/list/getbytitle(<list title>)/items?$Select=Title&$filter=Author eq <email> OR Column2 eq <some value>&$top=1
Even I checked with Microsoft team and they were surprised and said it’s part of core logic.