All page states within a space

1 Report output | 2 Report column descriptions | 3 Description | 4 Source for recipe

Report output

Report column descriptions

Column	Details

Column	Details
Page Title	The name of a page.
Current State	Name of the current Workflow State.
Last changed on	Date the last State change occurred.
Days ago	Time difference in days between the last State change and the current date.
Last changed by	Person who last changed the page's State.
Version	Current (Confluence) version of the page.

Description

This report allows you to retrieve all page States in a space. You can check the status of each page and the last update at a glance.

This recipe is convenient for managers who need to easily find pages that have not been updated in a while that require attention.

Source for recipe

<h2>All States in this Space</h2>
      <ac:structured-macro ac:macro-id="3a15bf46-9955-419f-93c1-3b2e38e7a534" ac:name="report-table" ac:schema-version="1">
        <ac:rich-text-body>
          <ac:structured-macro ac:macro-id="4965077e-1ab7-4c74-8a8e-a536cc674c6f" ac:name="content-reporter" ac:schema-version="1">
            <ac:parameter ac:name="types">page</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="aff2df05-1eee-4d37-8f59-7e6b2664924f" ac:name="text-sort" ac:schema-version="1">
                  <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="e95dd93f-7658-47bd-8d1f-0fc4f1510604" 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="e7ee31c4-dee3-4e73-a048-371f8fc5bdd3" 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="d5a7f5f6-3d81-4942-8177-d69674031014" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Current State</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="d72671bd-f73f-4d6a-a95b-71daaba48bc4" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="f3fac9f1-b8f1-49f6-971f-e489b99f8daa" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Last changed on</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="91d65e3d-3f75-434e-84f2-928ca891410f" 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="6b2d5b83-9ff8-46b2-bbe8-6fee45f32c7f" 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="d1e6a767-0df4-4f35-b95d-d1bf8a81b1b1" 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="fe5ff25c-78e0-4847-90c9-1ee98d703ccc" 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="d89f6339-96cd-4e47-86c7-5d8b85190d0f" 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="ea0cf2cf-9df4-44d8-bf54-e1fba949b56c" 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="98255ed6-9f86-46d3-810f-9c348a97f4ed" 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>
        </ac:rich-text-body>
      </ac:structured-macro>