Page Comparison

Column	Details
Page Title	The name of a page.
State changed on	Date the last workflow state change occurred.
Days ago	Time difference in days between the last workflow state change and the current date.
Last changed by	Person who last changed the workflow state for the page.
Version	Current (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 name to whatever you require.

Info
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 workflow state activity on a monthly basis.

Source code for recipe

Expand

title	Click here for the code source...

Code Block

language	xml

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

Versions Compared

Old Version 10

New Version 11

Key

Source code for recipe