I am trying to query a SharePoint list which has more than 5000 items. When I run filter query with ID, it returns the expected results. But when I run the same query with any other column it throws an error as shown below.
I know that there is a threshold limit of 5000. But I want to understand why am I getting the values when queried with ID column and not with any other column.