This report allows you to see all pages under the 'Approved' State within the last month. This is handy for auditors who need to check for page State activity on a monthly basis.


ColumnDetails
Page TitleThe name of a page.
State changed onDate the last State change occurred.
Days agoTime difference in days between the last State change and the current date.
Last changed byPerson who last changed the page's State.
VersionCurrent (Confluence) version of the page.

Tip

This recipe is not restricted to pages with the 'Approved' State, simply change the text-filter associated with the State's name to whatever you fancy:

Code Source

Click here for the code source...
<h2>All approved pages in the last month</h2>
      <ac:structured-macro ac:macro-id="10430f13-f06c-4a7c-8686-2bce5c2402e4" ac:name="report-table" ac:schema-version="1">
        <ac:rich-text-body>
          <ac:structured-macro ac:macro-id="199aee45-8f48-45fc-9ef8-6a2abfca819a" ac:name="content-reporter" ac:schema-version="1">
            <ac:parameter ac:name="types">page</ac:parameter>
            <ac:parameter ac:name="labels">product</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="06dce3d5-9d6e-4bf3-9e11-f33a9377c0c0" ac:name="date-filter" ac:schema-version="1">
                  <ac:parameter ac:name="minValue">-1m</ac:parameter>
                  <ac:parameter ac:name="beforeValue">1m</ac:parameter>
                  <ac:parameter ac:name="maxValue">%global:current date%</ac:parameter>
                  <ac:parameter ac:name="relativeTo">workflow:state&gt;date</ac:parameter>
                  <ac:parameter ac:name="">workflow:state&gt;date</ac:parameter>
                </ac:structured-macro>
              </p>
              <p>
                <ac:structured-macro ac:macro-id="aa2b91c0-cef0-44f4-ad6d-41660dcc56f5" ac:name="text-filter" ac:schema-version="1">
                  <ac:parameter ac:name="value">Approved</ac:parameter>
                  <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter>
                </ac:structured-macro>
              </p>
              <p>
                <ac:structured-macro ac:macro-id="d068ad07-cceb-48f7-bf63-5cfc091d9bc7" ac:name="text-sort" ac:schema-version="1">
                  <ac:parameter ac:name="">variable:Days Ago</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="da00b961-73f9-4bf7-a55d-f68f9a2925b0" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Page Title</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="11bf5953-8d26-4998-84e2-512d10cb861f" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="link">true</ac:parameter>
                  <ac:parameter ac:name="">content:title</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="25bb16b8-50a0-4726-a7fc-cd9759974cc6" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">State changed on</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="28f78f41-38c3-4d84-b816-29d7db3463c9" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
                  <ac:parameter ac:name="">workflow:state&gt;date</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="23d9cd99-d0bf-4824-b828-a709737d1fa5" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Days ago</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="28f13e19-0a25-4c01-8c8b-0d66c4e2fc40" ac:name="report-eval" ac:schema-version="1">
                  <ac:parameter ac:name="default">0</ac:parameter>
                  <ac:parameter ac:name="format">#</ac:parameter>
                  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                  <ac:parameter ac:name="">Days Ago</ac:parameter>
                  <ac:plain-text-body><![CDATA[(%global:current date>date:milliseconds% - %workflow:state>date>date:milliseconds%)/1000/60/60/24]]></ac:plain-text-body>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="f536bd09-e70e-4023-af93-830b345420c4" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Last changed by</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="528d3405-cf8e-497c-ad1a-2d55b242a176" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
                  <ac:parameter ac:name="link">true</ac:parameter>
                  <ac:parameter ac:name="">workflow:state&gt;user</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="d9034dca-2add-4d23-99f2-49e9f45f9fef" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Version</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="942d4d5a-5081-4567-a471-5e1d52d84c6c" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
                  <ac:parameter ac:name="">workflow:state&gt;version</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <p> </p>
          <p> </p>
          <ac:structured-macro ac:macro-id="f214a172-8a57-416b-9ffc-9a8729d70866" ac:name="report-empty" ac:schema-version="1">
            <ac:rich-text-body>
              <p>
                <em>No results found.</em>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <p> </p>
          <p> </p>
        </ac:rich-text-body>
      </ac:structured-macro>
XML