{"id":995,"date":"2012-12-19T06:56:01","date_gmt":"2012-12-19T06:56:01","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=995"},"modified":"2024-04-26T12:46:52","modified_gmt":"2024-04-26T12:46:52","slug":"creating-a-view-in-each-document-library-in-a-web-application","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/creating-a-view-in-each-document-library-in-a-web-application\/","title":{"rendered":"Creating a View in each Document Library in a Web Application"},"content":{"rendered":"

Crate a View in each Library in a Web App<\/h4>\n

My friend Rob Holmes raised an interesting challenge; deploying a new view to all libraries. Here\u2019s the script to apply it to all libraries with Content Types enabled that are Document Libraries, across all libraries in all webs in all site collections of a web application.<\/p>\n

Sorting\/filtering entries in a view requires the use of CAML, for which I provide a few examples commented in the script. To write CAML, one needs to know the available fields. If you have a $Lib, you can dump the static or internal names for every field in the library with this command:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
$Lib<\/code>.Fields | select internalname<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Here\u2019s some CAML examples.<\/p>\n

'<<\/code>OrderBy<\/code>><<\/code>FieldRef<\/code> Name<\/code>=<\/code>\"mvReceived_x0020_Time\"<\/code> Ascending<\/code>=<\/code>\"FALSE\"<\/code> \/><\/<\/code>OrderBy<\/code>><<\/code>Where<\/code>><<\/code>IsNotNull<\/code>><<\/code>FieldRef<\/code> Name<\/code>=<\/code>\"mvReceived_x0020_Time\"<\/code> \/><\/<\/code>IsNotNull<\/code>><\/<\/code>Where<\/code>>'<\/code><\/div>\n
'<<\/code>OrderBy<\/code>><<\/code>FieldRef<\/code> Name<\/code>=<\/code>\"mvSentOn\"<\/code> Ascending<\/code>=<\/code>\"FALSE\"<\/code> \/><\/<\/code>OrderBy<\/code>><<\/code>Where<\/code>><<\/code>IsNotNull<\/code>><<\/code>FieldRef<\/code> Name<\/code>=<\/code>\"mvReceived_x0020_Time\"<\/code> \/><\/<\/code>IsNotNull<\/code>><\/<\/code>Where<\/code>>'<\/code><\/div>\n
'<<\/code>OrderBy<\/code>><<\/code>FieldRef<\/code> Name<\/code>=<\/code>\"mvSentOn\"<\/code> Ascending<\/code>=<\/code>\"FALSE\"<\/code> \/><\/<\/code>OrderBy<\/code>><<\/code>Where<\/code>><<\/code>IsNotNull<\/code>><<\/code>FieldRef<\/code> Name<\/code>=<\/code>\"mvSentOn\"<\/code> \/><\/<\/code>IsNotNull<\/code>><\/<\/code>Where<\/code>>'<\/code><\/div>\n

There\u2019s a few good CAML builder tools. You can also just navigate an existing View and grab the XML from the View in SharePoint.<\/p>\n

Here\u2019s the script:<\/p>\n<\/div>\n<\/div>\n

  Add-PSSnapin \"Microsoft.SharePoint.PowerShell\" -ErrorAction SilentlyContinue\r\n$wa=get-spwebapplication http :\/\/SharePoint\r\n \r\nWrite-Host \"script starting $(get-date)\"\r\n \r\n$wa=get-spwebapplication http :\/\/SharePoint\r\n \r\nforeach ($Site in $wa.sites)\r\n{\r\n    if ($site.url -like $MatchStr)\r\n    {\r\n        $webs=$Site.AllWebs\r\n        $webcount = $Site.AllWebs.Count\r\n \r\n        for ($i=0; $i -lt $webcount; $i++)\r\n        {\r\n            $web=$webs[$i]\r\n \r\n            Write-Host \"working in $($web.url)\"\r\n \r\n            $lists=$web.lists;\r\n \r\n              for ($k=0; $k -lt $lists.count; $k++)\r\n              {\r\n                    $JPLib = $lists[$k];\r\n                         #don't bother adding a view to a hidden library\r\n                    if ($JPLib.Hidden)\r\n                    {\r\n                        continue;\r\n                    }\r\n                         #only for libraries, not for GenericList and other types\r\n                    if ($JPLib.BaseType -ne \"DocumentLibrary\")\r\n                    {\r\n                        continue;\r\n                    }\r\n                         #choose your own lib filter; this acts on every content type enabled library\r\n                    if ($JPLib.ContentTypesEnabled)\r\n                    {\r\n                    write-host -f green \"The Library $($JPLib.title) exists in the site $($web.url), about to tune the view\"\r\n                    try\r\n                    {\r\n                    $x=$JPLib.Views.get_Item(\"Email\")\r\n                    if ($x.id -ne $null) #prevents duplicate entries\r\n                    {\r\n                        $JPLib.Views.Delete($x.ID.ToString())\r\n                    }\r\n                    }\r\n                    catch\r\n                    {}\r\n                    if ($JPLib.Views[\"Email\"] -eq $null) #prevents duplicate entries\r\n                       {\r\n #$viewQuery = ''\r\n                     #$viewQuery = ''\r\n                     $viewQuery = ''\r\n \r\n                     $viewFields = New-Object System.Collections.Specialized.StringCollection\r\n                     $viewFields.Add(\"DocIcon\") > $null\r\n                     $viewFields.Add(\"LinkFilename\") >  $null\r\n                     $viewFields.Add(\"Title\") >  $null\r\n                     $viewFields.Add(\"mvTo\") >  $null\r\n                     $viewFields.Add(\"mvFrom\") >  $null\r\n                     $viewFields.Add(\"mvSubject\") >  $null\r\n                     $viewFields.Add(\"mvSentOn\") >  $null\r\n                     $viewFields.Add(\"mvAttach_x0020_Count\") >  $null\r\n                #    $viewFields.Add(\"DocType\") >  $null # this is accounting specific\r\n \r\n                     #RowLimit property\r\n                     $viewRowLimit = 50\r\n                     #Paged property\r\n                     $viewPaged = $true\r\n                     #DefaultView property\r\n                     $viewDefaultView = $false\r\n                     #$ViewQuery=$null;\r\n                     $viewTitle=\"Email\"\r\n                     $newview = $JPLib.Views.Add($viewTitle, $viewFields, $viewQuery, $viewRowLimit, $viewPaged, $viewDefaultView)\r\n                       }\r\n    }\r\n    }\r\n   }\r\n#} #foreach site\r\n} #if $true\/Siteurl is not null, if environment setup is valid\r\n}  <\/del><\/pre>\n","protected":false},"excerpt":{"rendered":"
Crate a View in each Library in a Web App My friend Rob Holmes raised an interesting challenge; deploying a new view to all libraries. Here\u2019s the script to apply it to all libraries with Content Types enabled that are Document Libraries, across all libraries in all webs in all site collections of a web […]<\/p>\n","protected":false},"author":4,"featured_media":996,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[26],"tags":[],"class_list":["post-995","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=995"}],"version-history":[{"count":4,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/995\/revisions"}],"predecessor-version":[{"id":1026,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/995\/revisions\/1026"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/996"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}