Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 9

...

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:

Code Block
<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

...

Image Added