Pages that require my approval

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

Report column descriptions

Column	Details
Column	Details
Page Title	The name of a page.
State	Name of the current workflow state.
Approval status	Current approval status.
Approval assigned to	Name(s) of user(s) that are assigned to the approval May be more than just the current user.
Outstanding tasks	List form of all the tasks on a page and other relevant information.
Last approved by	If there is more than one person in the assigned users, the last person who approved will show here If the Approval was made by an unassigned person, their name would not show here.
Description

This report allows you to retrieve a list of pages that require your Approval.
Other relevant information that can help you decide if an Approval is due is also attached in this report.
Source code for recipe

      <h2>Pages that require my approval</h2>
      <ac:structured-macro ac:macro-id="dc828550-5177-4c2b-8d35-13dbd298334d" ac:name="report-table" ac:schema-version="1">
        <ac:rich-text-body>
          <ac:structured-macro ac:macro-id="523e97b7-ab02-4780-9de7-ba3f10cda1a4" 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>
              <ac:structured-macro ac:macro-id="ec0e5dca-3edf-4186-a4a0-00d034597ab5" ac:name="collection-filter" ac:schema-version="1">
                <ac:parameter ac:name="matchFilters">any</ac:parameter>
                <ac:parameter ac:name="matchItems">any</ac:parameter>
                <ac:parameter ac:name="">workflow:approvals</ac:parameter>
                <ac:rich-text-body>
                  <p>
                    <ac:structured-macro ac:macro-id="8909a1ad-74ef-48c6-8be6-0d93a3f8e90f" ac:name="text-filter" ac:schema-version="1">
                      <ac:parameter ac:name="contains">%global:current user%</ac:parameter>
                      <ac:parameter ac:name="">assignees</ac:parameter>
                    </ac:structured-macro>
                  </p>
                </ac:rich-text-body>
              </ac:structured-macro>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="3badb13c-4c53-4e0a-86fe-aefd547cea90" 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="531936e3-488e-42a8-b76e-7bf5c9e19ce2" 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="b0489db2-30f1-48c6-8a0e-ca832dd1b456" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">State</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="777e2b93-4469-4acf-aedc-081709ea3dcb" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="render">wiki</ac:parameter>
                  <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="93d37f8b-ece0-4438-ac9f-00a30ac70a3a" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Approval status</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="61d25008-2a35-4e66-b8bb-f256f9dfad5e" ac:name="report-on" ac:schema-version="1">
                  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                  <ac:parameter ac:name="">workflow:approvals</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="43fe0b61-13e7-422c-a567-3373c045dc4a" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="">name</ac:parameter>
                      </ac:structured-macro> </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="183fc2ab-0bf1-482c-869b-b59bb66ee103" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Approval assigned to</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="2e729984-6b32-48db-a45d-c503f39dc9f8" ac:name="report-on" ac:schema-version="1">
                  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                  <ac:parameter ac:name="">workflow:approvals</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="c9504b33-5683-4d55-9ba8-b6ab5d34fe7d" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="link">true</ac:parameter>
                        <ac:parameter ac:name="">assignees</ac:parameter>
                      </ac:structured-macro> </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="f1c301a3-7f13-49c3-aefe-3ef2e0bb850b" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Outstanding tasks</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="41406696-ccae-4c45-8142-38cce209233b" ac:name="report-on" ac:schema-version="1">
                  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                  <ac:parameter ac:name="">workflow:tasks</ac:parameter>
                  <ac:rich-text-body>
                    <ac:structured-macro ac:macro-id="17fc94bb-43be-4236-82a8-f854894adb7b" ac:name="report-eval" ac:schema-version="1">
                      <ac:parameter ac:name="default">0</ac:parameter>
                      <ac:parameter ac:name="hidden">true</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-left</ac:parameter>
                      <ac:plain-text-body><![CDATA[(%duedate>date:milliseconds% - %global:current date>date:milliseconds%)/1000/60/60/24]]></ac:plain-text-body>
                    </ac:structured-macro>
                    <ul>
                      <li>
                        <strong>
                          <ac:structured-macro ac:macro-id="b94345e7-754a-4457-88c5-c99a9582ca12" ac:name="report-info" ac:schema-version="1">
                            <ac:parameter ac:name="default">-</ac:parameter>
                            <ac:parameter ac:name="link">true</ac:parameter>
                            <ac:parameter ac:name="">name</ac:parameter>
                          </ac:structured-macro>
                        </strong>, assigned to <ac:structured-macro ac:macro-id="dff44322-1d85-4439-9d2d-4d6979f48879" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="default">-</ac:parameter>
                          <ac:parameter ac:name="link">true</ac:parameter>
                          <ac:parameter ac:name="">assignees</ac:parameter>
                        </ac:structured-macro> by <ac:structured-macro ac:macro-id="f7395bc6-94dd-4fce-bc35-f93ac2c71abe" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="link">true</ac:parameter>
                          <ac:parameter ac:name="">user</ac:parameter>
                        </ac:structured-macro>, due <ac:structured-macro ac:macro-id="1526e74b-b289-407f-80a4-db9f7d99355b" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="default">-</ac:parameter>
                          <ac:parameter ac:name="format">dd MMM yyyy</ac:parameter>
                          <ac:parameter ac:name="">duedate</ac:parameter>
                        </ac:structured-macro> <span style="color: rgb(192,192,192);">(<ac:structured-macro ac:macro-id="c62808f9-ba88-423f-9a98-894ede2de33c" ac:name="report-info" ac:schema-version="1">
                            <ac:parameter ac:name="default">-</ac:parameter>
                            <ac:parameter ac:name="format">#</ac:parameter>
                            <ac:parameter ac:name="">variable:days-left</ac:parameter>
                          </ac:structured-macro> days left)</span>.<ul>
                          <li>
                            <em>Additional comments: <ac:structured-macro ac:macro-id="e4d3d80c-1234-4c4c-837c-9dd3934c9d57" ac:name="report-info" ac:schema-version="1">
                                <ac:parameter ac:name="default">-</ac:parameter>
                                <ac:parameter ac:name="">comment</ac:parameter>
                              </ac:structured-macro>
                            </em>
                          </li>
                        </ul>
                      </li>
                    </ul>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="0ad35292-e125-4ee9-b5af-ab46a9a3f3eb" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Last approved by</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="3ebd0765-3dd5-4704-af61-0af077fcebe5" ac:name="report-on" ac:schema-version="1">
                  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                  <ac:parameter ac:name="">workflow:approvals</ac:parameter>
                  <ac:rich-text-body>
                    <ac:structured-macro ac:macro-id="dabb4eed-a8b3-4bad-851d-78cd67bee852" ac:name="report-eval" ac:schema-version="1">
                      <ac:parameter ac:name="default">0</ac:parameter>
                      <ac:parameter ac:name="hidden">true</ac:parameter>
                      <ac:parameter ac:name="format">#</ac:parameter>
                      <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                      <ac:parameter ac:name="">approved-days-ago</ac:parameter>
                      <ac:plain-text-body><![CDATA[(%global:current date>date:milliseconds% - %date>date:milliseconds%)/1000/60/60/24]]></ac:plain-text-body>
                    </ac:structured-macro>
                    <p>
                      <ac:structured-macro ac:macro-id="78e25ddc-65a1-4a36-8c5b-71b537fae9b2" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="default">Unknown</ac:parameter>
                        <ac:parameter ac:name="link">true</ac:parameter>
                        <ac:parameter ac:name="">user</ac:parameter>
                      </ac:structured-macro> on <ac:structured-macro ac:macro-id="35f3b1d7-8594-4d8a-b097-365838302083" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="default">Not specified</ac:parameter>
                        <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
                        <ac:parameter ac:name="">date</ac:parameter>
                      </ac:structured-macro> <span style="color: rgb(192,192,192);">(<ac:structured-macro ac:macro-id="d514d1d0-d410-4f83-b2b9-3d7e0e153218" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="default">-</ac:parameter>
                          <ac:parameter ac:name="format">#</ac:parameter>
                          <ac:parameter ac:name="">variable:approved-days-ago</ac:parameter>
                        </ac:structured-macro> days ago)</span>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
        </ac:rich-text-body>
      </ac:structured-macro>