Group By Totals, Page Navigation and Sort Only by Specified Criteria – bug?
Posted by Dave Mellors | Filed under Fixes to problems, How To, SharePoint
When someone comes and tells me that SharePoint is behaving weird I’m not normally surprised. The way SharePoint works and it’s interface are not exactly intuitive but I can normally work out an explanation for the “weird” behaviour but not this time.
The Problem
I have a document library with 16 documents in it.
3 documents have the reporting week set to Week 1
4 documents have the reporting week set to Week 2
5 documents have the reporting week set to Week 3
4 documents have the reporting week set to Week 4
As you can see below, the view is grouped by Reporting Week, sorted by Created and I have set the item limit to a low number just to recreate the problem without having to create 100s of documents.
Page 1.
The first page looks perfectly normal and the group total for Week 2 is correct so when I click the arrow to goto the next page I would expect to see the other 2 documents for Week 2 but instead I see…
Page 2.
Where have the rest of Week 2 gone? All I can see if the 5 documents for Week 3 – perhaps they are on the next page?
Page 3.
Nope. No Week 2 documents are on Page 3. I know I will click the arrow to go back to the previous page…
Page 2 again
Oh! Now one of the missing Week 2 documents has appeared – but I’m still missing one.
Anyway you get the idea – it’s in a right mucking fuddle with groups totals correct but documents missing and no wonder the poor users of this site are confused.
The Fix
The fix!
Uncheck the checkbox for “Sort only by specified criteria” and the views work correctly with all documents visible and no there aren’t any folders are permission inheritance issues.
Tags: SharePoint 2010
