---
title: "Show the latest modification date of a space"
canonical: "https://support.appfire.com/space/REPS/475513690/Show%20the%20latest%20modification%20date%20of%20a%20space"
format: markdown
---
> Macro (aura-html)

## 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:

![image](media://cc7ffa39-b5a8-4953-ba1f-9a2f2dd1010a)

## Line-by-Line Explanation

| **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. |