All pages with the 'Approved' state in the last month

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.

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.

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

All pages with in the 'Approved' state in the last month

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