Page Comparison

...

Scenario

Using the Report On macro combined with Scaffolding, you are able to extract a set of dates from a Scaffolding table.

This recipe shows you how to display users who are having their birthday today.

Result

...

Recipe

Apps	Reporting for Confluence Server & Data Center, Scaffolding Forms & Templates for Confluence Server and Data Center
Level	Easy
Estimated time	15 Minutes
Macros	Number Filter, Report On, Report Variable
Suppliers	Date Supplier, Scaffolding Data Supplier, Variable Supplier

Storage format

You can copy and paste this code into the Confluence Source Editor:

Code Block

<p>
  <strong>List of Birthdays</strong>
</p>
<ac:structured-macro ac:macro-id="22439cf5-f14c-4da4-ad06-74d7c6bccc94" ac:name="table-data" ac:schema-version="1">
  <ac:parameter ac:name="">birthdayList</ac:parameter>
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <table>
      <tbody>
        <tr>
          <th>
            <p>Name</p>
          </th>
          <th>
            <p>Birthdate</p>
          </th>
        </tr>
        <tr>
          <td>
            <p class="auto-cursor-target">
              <br />
            </p>
            <ac:structured-macro ac:macro-id="5cf48023-6c8f-45c7-a822-03bebfd7dba9" ac:name="text-data" ac:schema-version="1">
              <ac:parameter ac:name="type">line</ac:parameter>
              <ac:parameter ac:name="content">text</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
              <ac:parameter ac:name="">name</ac:parameter>
              <ac:rich-text-body>
                <p>
                  <br />
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </td>
          <td>
            <p class="auto-cursor-target">
              <br />
            </p>
            <ac:structured-macro ac:macro-id="4aa57614-bd07-465a-b9f7-b57ebb47b766" ac:name="date-data" ac:schema-version="1">
              <ac:parameter ac:name="format">dd-MMM-yyyy</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
              <ac:parameter ac:name="">birthDate</ac:parameter>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </td>
        </tr>
      </tbody>
    </table>
    <p class="auto-cursor-target">
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <strong>Who's Celebrating Today?</strong>
</p>
<ac:structured-macro ac:macro-id="8012bf5a-8a86-4298-aa27-1baf31e95ce5" ac:name="report-on" ac:schema-version="1">
  <ac:parameter ac:name="injected">true</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="324c9b60-b71c-4a36-be0b-368f8accdc48" ac:name="report-block" ac:schema-version="1">
      <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
      <ac:rich-text-body>
        <p class="auto-cursor-target">
          <br />
        </p>
        <ac:structured-macro ac:macro-id="42600bb7-8902-4483-87cb-58f442eff515" ac:name="local-reporter" ac:schema-version="1">
          <ac:parameter ac:name="">data:birthdayList</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="2683a76a-d0db-4fa3-8f06-4dd705b216ac" ac:name="number-filter" ac:schema-version="1">
              <ac:parameter ac:name="minValue">%global:current date &gt; date:MMdd &gt; text:as number%</ac:parameter>
              <ac:parameter ac:name="maxValue">%global:current date &gt; date:MMdd &gt; text:as number%</ac:parameter>
              <ac:parameter ac:name="">data:birthDate &gt; date:MMdd &gt; text:as number</ac:parameter>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p class="auto-cursor-target">
          <br />
        </p>
        <ac:structured-macro ac:macro-id="5a3850df-9eec-4dd8-94bb-b1a9144717ac" ac:name="report-body" ac:schema-version="1">
          <ac:rich-text-body>
            <p>
              <ac:structured-macro ac:macro-id="36a532a5-58a4-46f5-b9c6-d690a87a5ce0" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="separator">comma</ac:parameter>
                <ac:parameter ac:name="">data:name</ac:parameter>
              </ac:structured-macro>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p class="auto-cursor-target">
          <br />
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
  <br />
</p>

Macro structure

You can recreate the example in the editor view:

...

Steps

N/A

Line-by-Line Explanation

N/A

...

Versions Compared

Old Version 11

New Version 12

Key