I’ve a customized checklist which at the moment comprise 7500 objects as comply with:-
and i’ve our checklist view which present all objects with out filtering and sorted by modified date as comply with:-
now i assumed that i’ll get threshold error on the checklist view, however appears it permit us to view all the info and apply field-based filtering and sorting on index columns inside traditional UI and even doing filtering on non-index columns inside trendy UI.. so has SharePoint not too long ago modified/expanded the edge checklist view limitation to permit viewing greater than 5000 objects?
Second query, now on the identical checklist i wrote the next CAML question to filter primarily based on an listed column:-
query1.ViewXml = "<View><Question><The place><Eq><FieldRef Identify ='CustomerOrderAlert0'/><Worth Sort='Alternative'>Sure</Worth></Eq></The place></Question><RowLimit>3000</RowLimit></View>";
now the question will work properly if the outcomes will probably be decrease 5,000 whereas if the results of the filter will probably be greater than 5,000 i’ll get this error contained in the code:-
'The tried operation is prohibited as a result of it exceeds the checklist view threshold enforced by the administrator.'
so why SharePoint permit viewing greater than 5,000 objects on checklist views whereas doesn’t permit this inside CAML queries?