Show the latest modification date of a space

Scenario

Reporting lets you see what spaces are active and what have lain dormant.

This recipe lets you find out when a space was last touched by a user (commented, edited, added, etc.)

The report may take some time to load, depending on the volume of content to report on.

Recipe

Apps	Reporting for Confluence Data Center
Level	Easy
Estimated time	10 minutes
Macros	Content Reporter, Date Sort, Report Column, Report Info, Report Table, Text Filter
Suppliers	Content Supplier

Storage format

You can copy and paste this code into the Confluence Source Editor:

<p class="auto-cursor-target">
  <br />
</p>
<ac:structured-macro ac:macro-id="61fe737f-49e5-4d22-999c-b8a9c9f7bd11" ac:name="report-table" ac:schema-version="1">
  <ac:parameter ac:name="maxResults">1</ac:parameter>
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="829914d0-fc70-4065-8fd4-8fc3ec3b85c1" ac:name="content-reporter" ac:schema-version="1">
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="7294b566-ddd4-43f4-920f-468c91ba247b" ac:name="date-sort" ac:schema-version="1">
          <ac:parameter ac:name="order">descending</ac:parameter>
          <ac:parameter ac:name="">content:modification date</ac:parameter>
        </ac:structured-macro> <ac:structured-macro ac:macro-id="1476996b-4ffa-4130-a521-f450857e60f4" ac:name="text-filter" ac:schema-version="1">
          <ac:parameter ac:name="exclude">This Page Name</ac:parameter>
          <ac:parameter ac:name="">content:title</ac:parameter>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="30fabbb7-999e-4959-b4c5-e407f025bf8e" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Date</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="66db3667-1c14-4b23-b76c-8d946ae74bac" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">content:modification date</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="6b9f22c5-8f90-49e6-9d4c-ec1ed17e6741" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Space</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="d7568051-6552-43ca-98d4-b025cc2e61b1" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">content:space</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="18372060-e37f-4a0a-bd57-03437516182f" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Last Modified Content</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="15124091-0e66-4b35-9865-dc1d70e7d52d" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">content:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
  <br />
</p>

Macro structure

You can recreate the example in the editor view:

Line-by-Line Explanation

Line	Description

Line	Description
1	The Report Table macro formats the report as a table. The macro parameter Maximum Results: `1` displays only the first (latest) content.
2	The Content Reporter macro with Spaces: `@self` grabs all the contents from the current space, including pages, news, and comments.
3	The Date Sort macro with Key: `content:modification date` and Order: `ascending` sorts the content by modification date, so the first item of the collection of contents is the one we are looking for.
4	The Text Filter macro with Key: `content:title` and Exclude: `<This Page Name>` excludes the current page, which, when updated, is technically the latest modified content.
5	Three Report Column macros create three columns with titles and report data. The titles of the three columns created are set to `Date`, `Space`, and `Last Modified Content`, in that order.
6	The Report Info macro with Key: `content:modification date` displays the date of modification of the content retrieved by the Content Reporter macro.
7	The Report Info macro with Key: `content:space` displays the space name of the content retrieved by the Content Reporter macro.
8	The Report Info macro with Key: `content:title` displays the title of the content retrieved by the Content Reporter macro.