Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
typeflat
separatorpipe
printablefalse

Report output

Report column descriptions

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

Description

Panel
bgColor#DEEBFF

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
titleClick here for the code source...All pages with in the 'Approved' state in the last month
Code Block
languagexml
<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>