Tag Info

Hot answers tagged

2

The SharePoint boundaries document (http://technet.microsoft.com/en-us/library/cc262787%28v=office.14%29.aspx) states that a list can contain 30,000,000 items. The query threshold is 5,000 items per operation. By default, a list view will request only 30 items per page, which is well below the threshold. Unless you alter the views, you should not have any ...


1

Use SPList.SaveAsTemplate for your source. Should be the same as the GUI.


1

An export to Excel will only ever export the view columns, not the grouping. You will need to build this in Excel from the ground up. Create a copy of that view. Add the grouping columns as view columns and don't group, then export. In Excel, build a pivot table. Drag all desired columns into the rows area. Set the pivot table to be a tabular format. ...


1

Just a note: these are NOT duplicate results. Every record is showing just once. It may seem like a duplicate entry since you don't group on the "Manual" field, but instead show every list item's "Manual" column value. This is not a bug. It is how SharePoint works. If you want the "manual" value showing only once, create a nested grouping under the ...


1

It's not an easy/sexy answer, but you could use Javascript/JQuery to iterate through the returned list items and just hide the duplicate rows.


1

Number of items in a list as per your description not a big because SharePoint can store millions of items in a List. Only problem is the List view Threshold, Number items are returns in a view cause the issue if it breach MSFT best practice limit( 5000 items). Their are ways to deal with large with i.e using the index column, metadata columns etc Here is ...



Only top voted, non community-wiki answers of a minimum length are eligible