---
title: "Page Approval report using Reporting for Confluence (Server/DC)"
canonical: "https://support.appfire.com/space/SUPPORT/670761647/Page%20Approval%20report%20using%20Reporting%20for%20Confluence%20(Server%2FDC)"
format: markdown
---
## Problem:

Using the [Page Approval Report macro](https://appfire.atlassian.net/wiki/pages/createpage.action?spaceKey=PAFS&title=Page%20Approval%20Report), there is a limitation of displaying only up to 100 results. By utilizing the [Reporting for Confluence](https://appfire.atlassian.net/wiki/spaces/REPS) app, you may overcome the limitation. This workaround will search on any pages with Page Approval macro from the current space and display them as a report.

## Solution:

Apply the following storage format to your page:

```
<p>
  <span style="font-size: 16.0px;font-weight: bold;letter-spacing: -0.006em;">Find pages with Page Approval macro</span>
</p>
<ac:structured-macro ac:macro-id="8a934ac0-ea0f-4a2a-9b5d-f559e512a8c3" ac:name="info" ac:schema-version="1">
  <ac:rich-text-body>
    <p>Results are limited to pages from current space</p>
  </ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="08580c73-5463-4f53-b477-0d7cf12a707e" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="a834f249-84ae-4dbf-b769-811b065508e9" ac:name="content-reporter" ac:schema-version="1">
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="7646da15-7821-4824-8c86-04a44f7e495f" ac:name="text-filter" ac:schema-version="1">
            <ac:parameter ac:name="contains">pageapproval</ac:parameter>
            <ac:parameter ac:name="required">true</ac:parameter>
            <ac:parameter ac:name="">content:body&gt;text</ac:parameter>
          </ac:structured-macro>
        </p>
        <p>
          <ac:structured-macro ac:macro-id="d42f9d4a-af44-4caa-8ee5-e46d73e72080" ac:name="text-sort" ac:schema-version="1">
            <ac:parameter ac:name="">page:modifcation date</ac:parameter>
          </ac:structured-macro>
        </p>
        <p>
          <ac:structured-macro ac:macro-id="2f5e4f84-3c37-4384-a3d9-f25777699b6a" ac:name="text-sort" ac:schema-version="1">
            <ac:parameter ac:name="">page:version comment</ac:parameter>
          </ac:structured-macro>
        </p>
        <p>
          <ac:structured-macro ac:macro-id="e9fc7c17-3e49-4614-86a5-a20b82d758e1" ac:name="text-filter" ac:schema-version="1">
            <ac:parameter ac:name="exclude">.*:.*</ac:parameter>
            <ac:parameter ac:name="">page:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="76882072-0f6b-4a44-9e8e-a8767f123293" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Space</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="7eb97dfc-174c-488a-9a10-9da6c02ea2cd" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">content:space</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="620dbfbd-4a0f-427e-a227-9a96454e71da" 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="279c45fb-7cc4-43f9-a590-896da0e54c6a" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">page:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="11359093-4141-45be-bb5a-8fe399a579eb" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Created</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="5bcfb1c1-9737-44e3-96eb-925d1157cf6a" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
            <ac:parameter ac:name="">content:creation date</ac:parameter>
          </ac:structured-macro> by <ac:structured-macro ac:macro-id="aaf4a407-07f7-4d91-9681-9d17e29d8c8b" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">content:creator</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="bd557e5b-72e8-4cf8-a4e9-95e409dacd28" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Page ID</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="06dd7a29-168c-4838-a741-85bdd9b6af5d" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">page:id</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="20fa9a1e-8570-482b-987d-d8e0f8cc48f5" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Last Modified</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="0a564230-8621-491b-b65b-1f50f76feeb0" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
            <ac:parameter ac:name="">content:modification date</ac:parameter>
          </ac:structured-macro> by <ac:structured-macro ac:macro-id="8fd829d4-7bad-42c4-82f5-7b12aafc343e" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">content:modifier</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="6a8b1a54-d902-40ba-88df-9c33b902f870" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Last version comment</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="20f83b31-0a4a-4667-817c-749c68d9d192" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
            <ac:parameter ac:name="">page:version comment</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
```

You can filter the result further based on the approver by searching for the specific user; however this requires you to get the `userkey` for that user and enter that value into the seconds [Text Filter](https://apps-docs.servicerocket.com/reporting/text-filter) macro as follows:

![image](media://3a347d31-2329-41a9-b758-75b5b94491a3)

 

In order to get the user key, you can create a page and add your desired user as an approver (into `Users` field) and save the page. View the page [storage format](https://confluence.atlassian.com/confkb/how-to-retrieve-confluence-storage-format-1014270532.html) and grab the `userkey` value.

![image](media://08595106-1e12-4c6d-b080-397a7833ce4e)

## \uD83D\uDCCB Related articles



> Macro (contentbylabel)