Content and Structure Reports

$Banner – The Hand Society serves hand specialists such as hand surgeons, hand therapists and other hand care professionals who help patients with hand injuries and hand diseases such as carpal tunnel, hand fractures and more.$

Report Title	CAML Query	Report Description
Checked Out To Me	<Where><Eq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="int"><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="int"><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="int"><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
Pages And Documents Modified In The Last 30 Days	<Where><Geq><FieldRef Name="Modified" /><Value Type="DateTime"><Today OffsetDays="-30" /></Value></Geq></Where><OrderBy><FieldRef Name="Modified" Ascending="False" /></OrderBy>	All pages and documents modified by anyone in the last 30 days in this site and subsites