Content and Structure Reports - All Items - École Kelowna Secondary

Skip to main content

SD23 Dashboard

École Kelowna Secondary

Where all are Valued

Content and Structure Reports

Use the reports list to customize the queries that appear in the Content and Structure Tool views

	Report Title	CAML Query	Target Audiences	Report Description
	Checked Out To Me	<Where><Eq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>		All documents and pages checked out to me in this site and subsites
	Last Modified By Me	<Where><Eq><FieldRef Name="Editor" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>		All documents and pages last modified by me in this site and subsites
	Pending Approval	<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">2</Value></Eq></Where>		All documents and pages submitted by me and waiting for approval in this site and subsites
	My Tasks	<Where><Or><Eq><FieldRef Name="AssignedTo" LookupId="TRUE"/><Value Type="Integer"><UserID /></Value></Eq><Membership Type="CurrentUserGroups"><FieldRef Name="AssignedTo"/></Membership></Or></Where><OrderBy><FieldRef Name="DueDate"/></OrderBy>		All tasks assigned to me in this site and subsites
	All Draft Documents	<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">3</Value></Eq></Where>		All documents and pages not yet published in this site and subsites
	Going Live Within Next Seven Days	<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>		All 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 Days	<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>		All documents and pages that will only be visible to authorized users within the next seven days in this site and subsites