Zhaobab
8/11/2015 - 3:39 PM

Edit all views in a single site collection

Edit all views in a single site collection

# ----------------------------------------------
# Author: Romain Blanchard
# Date: 11.08.2015
# Description: Edit all views in a single site collection
# ----------------------------------------------

Add-PSSnapin Microsoft.SharePoint.Powershell

$SiteUrl = "http://mycpdintg.intg2013.dpgp.emea.loreal.intra/sites/ipanel"
$ViewName = "Published Folders"

$site = Get-SPSite $SiteUrl
foreach ($web in $site.AllWebs)
{
    for($i=0;$i -lt $web.Lists.Count;$i++)
    {    
        $views = $web.Lists[$i].Views | Where {$_.Title -eq $ViewName}
        foreach ($view in $views)
        {
            $view.Query = $view.Query.Replace('$Resources:MyCPDResources,FIELDS_iPanelAlertsIsReady_ValueReady;','Published')
            $view.Update()
        }
    }
}

Write-Host "Done !" -ForegroundColor Yellow