Limited to 300 list items?

Jul 20, 2011 at 12:56 PM

Hi folks...am curious if the new version limits its display and 'pivot' to 300 items in a SharePoint list...  we had the previous version installed and were able to get near 2000 items to display.  Am I missing a setting?

 

Thanks,

Dean

Jul 20, 2011 at 1:24 PM

I see 4 files that indicate a 'query limit' of 300.  I imagine we'll simply have to edit those values and recompile.  Any other suggestions?

Coordinator
Jul 21, 2011 at 2:58 PM

Hello

Not exactly, in fact you have a new page in site settings where you can put max item to show, by default it's 300

Jul 21, 2011 at 3:50 PM

It appears the limit is 999.  Is this also configurable?  If not, is this an easy code change?

Coordinator
Jul 21, 2011 at 4:38 PM

Yes it's really easy to change in /layouts/SPPivotViewer/SPPivotViewerSettings.aspx

change

<SharePoint:InputFormTextBox Title="Max Number of elements"
                    class="ms-input"
                    ID="txtThrottling"
                    Runat="server"
                    MaxLength="3"  />
by

<SharePoint:InputFormTextBox Title="Max Number of elements"
                    class="ms-input"
                    ID="txtThrottling"
                    Runat="server"
                    MaxLength="4"  />
and the limit will be 9999 :)

Jul 21, 2011 at 5:47 PM

Awesome!  Thank you for the quick reply!

Coordinator
Jul 21, 2011 at 6:21 PM

I will increase this limit for the next minor version.