The Baretta

Ever had this issue on SharePoint Online? "This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator."  "To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold." Well I have, and it sucks. My particular issue was that someone had uploaded 120,000 files to a document library, which they then wanted to add metadata to, however, being a bulk upload, they weren't adding it as they were going, so in turn, any sorting/filtering of such a large bank of files let to the famous error above. Of course you can't bypass the LVT (list view threshold), but as we all (should!) know, is that once you have added metadata, you can do things to avoid it. My solution to this issue is not quick, but it worked.  I created a view showing only

Any well utilised SharePoint farm will hit this limit at one point or another, the annoying but not hard to resolve LIST VIEW THRESHOLD ISSUE!!!!!! If you're on the ball, you'll know to cater for this when first creating a list you know is going to be quite popular with the lads.  This involves creating indexed columns, and creating views that filter on the indexed columns. But woe to those who wait for the dreadful message to appear, and also to those who prepared for it, but it is still occurring anyway.   WHHHHHHYYYYYYYYYYYYYYYYYYY!!!!!!!!!!!!.... STOP!  CAML TIME! Well it's because when you modify a view using the SharePoint GUI, and you filter on a indexed column and maybe a few others, SharePoint turns your filters & options into a CAML query, and if that query contained a few different column filters, SharePoint occasionally doesn't render the CAML query in a manner that ensures you are always querying less than the List View Threshold! OH N