I’ve an inventory that is butting up towards the 5000 merchandise threshold and I’ve added a pair dummy objects so I can experiment with the edge earlier than I cross over with actual information. My record is structured so that every merchandise is exclusive (enforced) however will be assigned to a number of initiatives. Then I create a view filter for every undertaking quantity which shows (and lets me manipulate) solely the objects assigned to that undertaking.
The 256 character restrict on “single line of textual content” columns has compelled me to create a number of “undertaking” columns through the years and lots of of my objects have entries in every column. Every undertaking view makes use of a filter on all undertaking columns, so “Project1 incorporates [project number], or Project2 incorporates [project number], or Project3 incorporates [project number], and many others”. Every view returns about 50-100 objects, so it ought to work superb with Sharepoint’s giant website guidelines.
This scheme works completely underneath 5000 objects, however as quickly as I cross over it errors out. I’ve listed all undertaking columns but it surely nonetheless would not work. I feel it could need to do with utilizing a number of “or” situations on the view, however I have not discovered any official steering or workarounds but.
Does anyone have any options on deal with this? It looks like I both want a brand new technique to filter the record or a way of mixing all the undertaking columns into one. I would like to consolidate all undertaking numbers right into a multi line column, however apparently these cannot be used for filtering.
I nonetheless have the nuclear possibility of opening up the edge to some quantity that I will in all probability by no means hit, however I would like to do it accurately. I am the one consumer of this record, so I actually do not care concerning the useful resource hit so long as the record nonetheless features.