PowerShell - get items by view

Question

I've run into an issue whereby running the below code will only return the items within the current page of a view. I.e. If I have 30 items in my view, but 60 total, I will only be returned 30 items.

$web = Get-SPWeb $($webUrl);
$list = $web.Lists.get_Item($listName);
$view = $list.Views[$viewName];
$items = $list.GetItems($view);

Question: Is there a way to query the view and get all items, regardless of any paging?

Paul Strupeikis · Accepted Answer · 2016-04-27 14:27:43Z

3

Yes, there is a way. You need to use an SPQuery object (based on your SPView). Use the following PowerShell commands:

$web = Get-SPWeb $($webUrl);
$list = $web.Lists.get_Item($listName);
$view = $list.Views[$viewName];
$spQuery = New-Object Microsoft.SharePoint.SPQuery($view)
$spQuery.RowLimit = 0
$items = $list.GetItems($spQuery);

edited Apr 27, 2016 at 14:27

answered Apr 27, 2016 at 13:32

Paul Strupeikis

3,8184 gold badges22 silver badges34 bronze badges

Add a comment |

Stack Exchange Network

PowerShell - get items by view

1 Answer 1

Your Answer

Hot Network Questions

PowerShell - get items by view

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions