now i thought that i will get threshold error on the list view, but seems it allow us to view all the data and apply field-based filtering and sorting on index columns inside classic UI and even doing filtering on non-index columns inside modern UI.. so has SharePoint recently changed/expanded the threshold list view limitation to allow viewing more than 5000 items?
Second question, now on the same list i wrote the following CAML query to filter based on an indexed column:-
query1.ViewXml = "<View><Query><Where><Eq><FieldRef Name ='CustomerOrderAlert0'/><Value Type='Choice'>Yes</Value></Eq></Where></Query><RowLimit>3000</RowLimit></View>";
now the query will work well if the results will be lower 5,000 while if the result of the filter will be more than 5,000 i will get this error inside the code:-
'The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.'
so why SharePoint allow viewing more than 5,000 items on list views while does not allow this inside CAML queries?