Tag Info

Hot answers tagged

2

Get the web and list: $w = Get-SPWeb http://localhost $l = $w.Lists["My list"]; This is how you select the view "All items": $view = $l.Views | ? { $_.Title -eq 'All items' } Then just add fields: $view.ViewFields.Add($hereGoesFieldName); And update view: $view.Update();


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

There are two ways: Create a view where you filter for the value of the last modified field, and compare it to the value of [today-7]. Create a view with calculated column with filter =[Modified]+7, and its return type is DateTime, which will returns the documents changed within the last 7 days more information on creating view and filter is here ...


1

Retrieve All Items view by using $myList.DefaultView if it is a default view or by using the index $myList.Views["All Items"]. Then add fields to it and finally update it. $defaultView = $myList.DefaultView; // Repeat this line for all fields $defaultView.ViewFields.Add($myList.Fields["FieldName"]); $defaultView.Update();


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