List Scaffolding data categorized by page

Scenario

List Scaffolding Forms & Templates for Confluence Data Center data categorized by page.
Result

Recipe

Apps	Reporting for Confluence Data Center, Scaffolding Forms & Templates for Confluence Data Center
Level	Intermediate
Estimated time	30 minutes
Macros	Content Reporter, Expanding Reporter, Report Column, Report Info, Report Table, Text Filter
Suppliers
Storage format

You can copy and paste this code into the Confluence Source Editor:
<p>If data is inside the table:</p>
<ac:structured-macro ac:macro-id="b28d96d3-d175-482a-b788-0a7c6fb1ef9d" ac:name="table-data" ac:schema-version="1">
  <ac:parameter ac:name="name">td</ac:parameter>
  <ac:rich-text-body>
    <table class="wrapped">
      <colgroup>
        <col />
      </colgroup>
      <tbody>
        <tr>
          <th>
            <p>text</p>
          </th>
        </tr>
        <tr>
          <td>
            <div class="content-wrapper">
              <ac:structured-macro ac:macro-id="02aa36dc-8e39-4d95-8ce2-7ee9c42e626a" ac:name="text-data" ac:schema-version="1">
                <ac:parameter ac:name="name">tdt</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:rich-text-body>
                  <p>
                    <br />
                  </p>
                </ac:rich-text-body>
              </ac:structured-macro>
            </div>
          </td>
        </tr>
      </tbody>
    </table>
  </ac:rich-text-body>
</ac:structured-macro>
<p>Then use an expanding-reporter:</p>
<ac:structured-macro ac:macro-id="56c5182a-d0ab-448b-bccc-bcf175a5aed1" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="e06bfe89-504c-47ad-afbe-f401a0a10214" ac:name="expanding-reporter" ac:schema-version="1">
      <ac:parameter ac:name="as">exr</ac:parameter>
      <ac:parameter ac:name="">data:td</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="87138386-49a7-4aae-863a-ea04d8945ab3" ac:name="content-reporter" ac:schema-version="1">
          <ac:rich-text-body>
            <p>
              <br />
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="b363cb0a-efe3-4250-beda-788195f9a316" 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="f7091891-c3d8-47a9-8fb4-13f1d418fcd8" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">expanded:item&gt;page:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="e00a4d46-372a-4553-aaac-a38e8f7f60e9" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">tdtText</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="1e929406-3245-4348-b4b4-29283036d182" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="render">richtext</ac:parameter>
            <ac:parameter ac:name="">expanded:exr&gt;data:tdt</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<p>If the data is not contained in any other data:</p>
<ac:structured-macro ac:macro-id="18049d04-6529-4cd9-8f17-50f3c96b3f4d" ac:name="text-data" ac:schema-version="1">
  <ac:parameter ac:name="name">tdt</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <p>
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p>Then we only need to report the pages and then filter out the page that doesn't have the data:</p>
<ac:structured-macro ac:macro-id="efe13903-951c-415f-9b0b-5eafba12aba1" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="a9a1d3f0-d975-4225-a6c4-fbae37ee798a" ac:name="content-reporter" ac:schema-version="1">
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="f2faf76f-c3ae-4beb-a4bb-f14583c64c5f" ac:name="text-filter" ac:schema-version="1">
          <ac:parameter ac:name="required">true</ac:parameter>
          <ac:parameter ac:name="">data:tdt</ac:parameter>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="ab86519f-73c4-4272-a7c5-91fb5afde037" 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="5b5dd687-10f3-416f-bddf-fe36be2f5bcf" 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="42b70bb9-57de-44d6-b05b-0a998073ed2a" ac:name="report-column" ac:schema-version="1">
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="5ce8229e-1e4b-4a29-b2d3-339962decc7b" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="render">richtext</ac:parameter>
            <ac:parameter ac:name="">data:tdt</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>