Scenario

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

Result

Recipe

Apps


Reporting for Confluence Server & Data Center, Scaffolding Forms & Templates for Confluence Server and 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>

Macro structure

You can recreate the example in the editor view:

  • N/A

Steps

  • N/A

Line-by-Line Explanation

  • N/A