Skip to main content

Home

Go Search
Home
Patients
Services
GPs
Research
Education
Jobs
About
Contact
  
Home > Content and Structure Reports  

Content and Structure Reports

Modify settings and columns
Use the reports list to customize the queries that appear in the Content and Structure Tool views
  
View: 
Target AudiencesFilter
Checked Out To MeUse SHIFT+ENTER to open the menu (new window).
<Where><Eq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="int"><UserID/></Value></Eq></Where>NoAll documents and pages checked out to me in this site and subsites
Last Modified By MeUse SHIFT+ENTER to open the menu (new window).
<Where><Eq><FieldRef Name="Editor" LookupId="TRUE"/><Value Type="int"><UserID/></Value></Eq></Where>NoAll documents and pages last modified by me in this site and subsites
Pending ApprovalUse SHIFT+ENTER to open the menu (new window).
<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">2</Value></Eq></Where>NoAll documents and pages submitted by me and waiting for approval in this site and subsites
My TasksUse SHIFT+ENTER to open the menu (new window).
<Where><Or><Eq><FieldRef Name="AssignedTo" LookupId="TRUE"/><Value Type="int"><UserID /></Value></Eq><Membership Type="CurrentUserGroups"><FieldRef Name="AssignedTo"/></Membership></Or></Where><OrderBy><FieldRef Name="DueDate"/></OrderBy>NoAll tasks assigned to me in this site and subsites
All Draft DocumentsUse SHIFT+ENTER to open the menu (new window).
<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">3</Value></Eq></Where>NoAll documents and pages not yet published in this site and subsites
Going Live Within Next Seven DaysUse SHIFT+ENTER to open the menu (new window).
<Where><And><Leq><FieldRef ID="{51d39414-03dc-4bd0-b777-d3e20cb350f7}"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef ID="{51d39414-03dc-4bd0-b777-d3e20cb350f7}"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>NoAll documents and pages that will be published and visible to readers within the next seven days in this site and subsites
Expiring Within Next Seven DaysUse SHIFT+ENTER to open the menu (new window).
<Where><And><Leq><FieldRef ID="{a990e64f-faa3-49c1-aafa-885fda79de62}"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef ID="{a990e64f-faa3-49c1-aafa-885fda79de62}"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>NoAll documents and pages that will only be visible to authorized users within the next seven days in this site and subsites
UCLH Expiry in the next weekUse SHIFT+ENTER to open the menu (new window).
<Where><And><Leq><FieldRef Name="UCLH_ExpiryDate"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef Name="UCLH_ExpiryDate"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>NoPages where the UCLH Expiry date is set to expire in the next week
UCLH ExpiredUse SHIFT+ENTER to open the menu (new window).
<Where><Leq><FieldRef Name="UCLH_ExpiryDate"></FieldRef><Value Type="DateTime">[Today + 0]</Value></Leq></Where>NoPages where the UCLH Expiry date as already passed
UCLH Expiry date >= 7 & <= 28 daysUse SHIFT+ENTER to open the menu (new window).
<Where><And><Leq><FieldRef Name="UCLH_ExpiryDate"></FieldRef><Value Type="DateTime">[Today + 28]</Value></Leq><Geq><FieldRef Name="UCLH_ExpiryDate"/><Value Type="DateTime"><[Today + 7] /></Value></Geq></And></Where>NoPages where the UCLH Expiry date is more than or equal to 7 days and less than or equal to 28 days away
UCLH Date Not SetUse SHIFT+ENTER to open the menu (new window).
<Query><Where><IsNull><FieldRef Name='UCLH_ExpiryDate' /></IsNull></Where></Query>NoAll Pages where the UCLH Expiry date has not been set