{"id":1792,"date":"2017-05-18T15:38:16","date_gmt":"2017-05-18T13:38:16","guid":{"rendered":"https:\/\/blog.kodono.info\/wordpress\/?p=1792"},"modified":"2017-05-18T15:38:43","modified_gmt":"2017-05-18T13:38:43","slug":"create-an-unpublished-content-view-for-the-masterpage-galery-sharepoint","status":"publish","type":"post","link":"https:\/\/blog.kodono.info\/wordpress\/2017\/05\/18\/create-an-unpublished-content-view-for-the-masterpage-galery-sharepoint\/","title":{"rendered":"Create an Unpublished Content view for the masterpage galery [Sharepoint]"},"content":{"rendered":"

With Sharepoint 2013 I wanted an easy way to list of the pages in my masterpage galery that haven’t been published yet.<\/p>\n

You first need to Create a new view<\/strong> named Unpublished Content<\/strong>. You can sort by Name<\/strong>, and scroll down to the Folders settings<\/strong> and choose Show all items without folders<\/strong>.<\/p>\n

We now have all our files in the view.<\/p>\n

Next, switch to the Library ribbon<\/strong> and choose Modify in SharePoint Designer (Advanced)<\/strong> from the Modify View dropdown<\/strong>.<\/p>\n

Sharepoint Designer will open your page.<\/p>\n

In Sharepoint Designer, switch to the <\/strong>Home<\/strong> tab and choose Advanced Mode<\/strong>. The file is reloaded.<\/p>\n

Search into your code the tag ListViewXml<\/strong>. On this line you should have &lt;Query;&&gt;<\/strong>. Just after it, we need to add:
\n&lt;Where&gt;&lt;Or&gt;&lt;Eq&gt;&lt;FieldRef Name=\"_ModerationStatus\" \/&gt;&lt;Value Type=\"ModStat\"&gt;Draft&lt;\/Value&gt;&lt;\/Eq&gt;&lt;IsNotNull&gt;&lt;FieldRef Name=\"CheckoutUser\" \/&gt;&lt;\/IsNotNull&gt;&lt;\/Or&gt;&lt;\/Where&gt;<\/code><\/p>\n

Before:
\n\"\"
\nAfter:
\n\"\"(click to enlarge)<\/a><\/p>\n

Save, and your view should only show the unpublished content!<\/p>\n

(Article inspired by https:\/\/thechriskent.com\/2013\/02\/14\/unpublished-view\/<\/a>)<\/p>\n","protected":false},"excerpt":{"rendered":"

With Sharepoint 2013 I wanted an easy way to list of the pages in my masterpage galery that haven’t been published yet. You first need to Create a new view named Unpublished Content. You can sort by Name, and scroll down to the Folders settings and choose Show all items without folders. We now have […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","hide_page_title":"","footnotes":""},"categories":[15,170,20],"tags":[153,123,155,117],"class_list":["post-1792","post","type-post","status-publish","format-standard","hentry","category-astuce","category-english","category-niveau-expert","tag-astuce","tag-english","tag-niveau-expert","tag-sharepoint"],"_links":{"self":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1792","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/comments?post=1792"}],"version-history":[{"count":6,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1792\/revisions"}],"predecessor-version":[{"id":1800,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1792\/revisions\/1800"}],"wp:attachment":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/media?parent=1792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/categories?post=1792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/tags?post=1792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}