Home

Library View filter begins with number

%3CLINGO-SUB%20id%3D%22lingo-sub-1051335%22%20slang%3D%22en-US%22%3ELibrary%20View%20filter%20begins%20with%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051335%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20Library%20in%20SharePoint%20Online.%20As%20there%20are%20over%205000%20items%2C%20grouping%20is%20not%20working.%20Microsoft%20support%20recommended%20I%20create%20a%20series%20of%20views%20for%20every%20letter%20of%20the%20alphabet%20which%20stinks%20but%20I%20did%20it%20and%20its%20working.%20I%20also%20have%20many%20items%20that%20start%20with%20a%20number%20and%20I%20would%20like%20to%20create%20a%20view%20just%20for%20items%20the%20begin%20with%20any%20number%20but%20I%20don't%20see%20a%20way%20to%20do%20this%20without%20creating%20a%20view%20for%20each%20number%200-9.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1051335%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1051700%22%20slang%3D%22en-US%22%3ERe%3A%20Library%20View%20filter%20begins%20with%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051700%22%20slang%3D%22en-US%22%3Ecan't%20just%20add%20multiple%20Startswith%200%20OR%20Startswith%201%20OR%20Startswith%202%20etc.%20down%20the%20list%20in%20the%20filter%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1052744%22%20slang%3D%22en-US%22%3ERe%3A%20Library%20View%20filter%20begins%20with%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1052744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3Byou%20can%20only%20have%209%20filters%2C%20there%20are%2010%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1052759%22%20slang%3D%22en-US%22%3ERe%3A%20Library%20View%20filter%20begins%20with%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1052759%22%20slang%3D%22en-US%22%3EGuess%20lets%20go%20back%20to%20the%20root%20issue.%20What%20does%20view's%20by%20letter%20accomplish%3F%20What%20is%20the%20end%20goal%20as%20far%20as%20returning%20documents%20themselves%20here%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1052933%22%20slang%3D%22en-US%22%3ERe%3A%20Library%20View%20filter%20begins%20with%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1052933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BWe%20have%20a%20document%20library%20in%20the%20cloud%20with%205678%20documents%20and%20since%20we've%20exceeded%20the%205000%20item%20threshold%20our%20views%20are%20broken%20with%20regard%20to%20grouping.%20After%20MANY%20conversations%20with%20Microsoft%20support%20it%20has%20been%20recommended%20by%20support%20that%20grouping%20is%20out%20in%20views%20and%20grouping%20by%20view%20is%20what%20we%20need%20to%20do.%20Kind%20of%20a%20hack%20job%20work%20around%20but%20that%20was%20our%20option.%20So%20I'm%20left%20with%20creating%20a%20huge%20list%20of%20views%2C%20both%20alphabetically%2C%20numerically%20and%20by%20content%20type.%20All%20of%20which%20is%20very%20interesting%20as%20documentation%20tells%20us%20there%20is%20a%2050%20view%20limit%20for%20a%20list%20or%20library%20but%20Microsoft%20tells%20us%20there%20is%20no%20limit%20online...%20What%20a%20mess%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

I have a large Library in SharePoint Online. As there are over 5000 items, grouping is not working. Microsoft support recommended I create a series of views for every letter of the alphabet which stinks but I did it and its working. I also have many items that start with a number and I would like to create a view just for items the begin with any number but I don't see a way to do this without creating a view for each number 0-9. 

 

Any suggestions?

4 Replies
Highlighted
can't just add multiple Startswith 0 OR Startswith 1 OR Startswith 2 etc. down the list in the filter?
Highlighted

@Chris Webb you can only have 9 filters, there are 10 numbers.

Highlighted
Guess lets go back to the root issue. What does view's by letter accomplish? What is the end goal as far as returning documents themselves here?

@Chris Webb We have a document library in the cloud with 5678 documents and since we've exceeded the 5000 item threshold our views are broken with regard to grouping. After MANY conversations with Microsoft support it has been recommended by support that grouping is out in views and grouping by view is what we need to do. Kind of a hack job work around but that was our option. So I'm left with creating a huge list of views, both alphabetically, numerically and by content type. All of which is very interesting as documentation tells us there is a 50 view limit for a list or library but Microsoft tells us there is no limit online... What a mess