Skip to end of banner
Go to start of banner

Creating an IF ELSE statement with Reporting

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Current »

Scenario

This recipe allows you to create an IF ELSE statement using Reporting and Scaffolding Forms & Templates for Confluence Server and Data Center instead of using reporting data via the Report Body and Report Empty macros.

This also replaces the legacy report structure where you place text filter macros into Report Body or Report Column.

Result

Recipe

Apps

Scaffolding Forms & Templates for Confluence Server and Data Center, Reporting for Confluence Server & Data Center

Level

Advanced

Estimated time

30 minutes

Macros

Local Reporter, Report Block, Report Body, Report Column, Report Info, Report Table, Text Filter

Suppliers

Scaffold Data Supplier

Storage format

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

<p class="auto-cursor-target">
  <br />
</p>
<ac:structured-macro ac:macro-id="64391ff8-0d58-4b9f-afaf-7d7d36a08b47" ac:name="hidden-data" 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="0022dcfb-82a6-4120-93a2-09eff255f04a" ac:name="table-data" ac:schema-version="1">
      <ac:parameter ac:name="name">mytable</ac:parameter>
      <ac:rich-text-body>
        <p class="auto-cursor-target">
          <br />
        </p>
        <table>
          <tbody>
            <tr>
              <th>
                <p>Title</p>
              </th>
              <th>
                <p>Status</p>
              </th>
            </tr>
            <tr>
              <td>
                <p class="auto-cursor-target">
                  <br />
                </p>
                <ac:structured-macro ac:macro-id="64f7715e-e0cf-4b65-87ec-3a9eb4373d8e" ac:name="text-data" ac:schema-version="1">
                  <ac:parameter ac:name="name">mytitle</ac:parameter>
                  <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: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="850c3f36-e248-46c3-bf2a-d0490e2bd41d" ac:name="list-data" ac:schema-version="1">
                  <ac:parameter ac:name="name">mystatus</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="2a74714e-fa90-434b-b5ae-768eeebfb2d5" ac:name="list-option" ac:schema-version="1">
                      <ac:parameter ac:name="value">Approved</ac:parameter>
                      <ac:rich-text-body>
                        <ac:structured-macro ac:macro-id="d62f9782-960d-4398-bf5d-f43c64fcb8cf" ac:name="status" ac:schema-version="1">
                          <ac:parameter ac:name="color">green</ac:parameter>
                          <ac:parameter ac:name="title">Approved</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="cd26b663-f7a7-4646-bf14-a9b5161bd258" ac:name="list-option" ac:schema-version="1">
                      <ac:parameter ac:name="value">Rejected</ac:parameter>
                      <ac:rich-text-body>
                        <ac:structured-macro ac:macro-id="a51b416e-4ff4-45e2-85ee-34e1add74064" ac:name="status" ac:schema-version="1">
                          <ac:parameter ac:name="color">red</ac:parameter>
                          <ac:parameter ac:name="title">Rejected</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="422eee78-d0c5-48ad-a8b4-7181a11bd2ac" ac:name="list-option" ac:schema-version="1">
                      <ac:parameter ac:name="value">In Progress</ac:parameter>
                      <ac:rich-text-body>
                        <ac:structured-macro ac:macro-id="301603e4-73f5-4fbb-9c4d-ef0a875dd4d4" ac:name="status" ac:schema-version="1">
                          <ac:parameter ac:name="color">yellow</ac:parameter>
                          <ac:parameter ac:name="title">In Progress</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="ea824718-a4b8-4b39-99c6-d8e033949bf8" ac:name="list-option" ac:schema-version="1">
                      <ac:parameter ac:name="value">Unassigned</ac:parameter>
                      <ac:rich-text-body>
                        <ac:structured-macro ac:macro-id="05cea2f5-98a7-48d4-884d-a89b07a182c2" ac:name="status" ac:schema-version="1">
                          <ac:parameter ac:name="color">grey</ac:parameter>
                          <ac:parameter ac:name="title">Unassigned</ac:parameter>
                        </ac:structured-macro>
                      </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>
              </td>
            </tr>
          </tbody>
        </table>
        <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>
<hr />
<h3>Method 1:</h3>
<ac:structured-macro ac:macro-id="4fdc5621-8cb5-430a-93d2-c45566413355" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="7da805b6-6c84-4250-88f5-649e50426735" ac:name="local-reporter" ac:schema-version="1">
      <ac:parameter ac:name="source">@self</ac:parameter>
      <ac:parameter ac:name="">data:mytable</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br />
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="fd45bb09-3559-43e2-a68e-08e23ddaf11d" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Title</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="45082d44-e4f5-46c8-8dad-51217b623407" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:mytitle</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="f98fefb0-96e9-40ad-b422-7d74d9c329f0" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Status</ac:parameter>
      <ac:rich-text-body>
        <p class="auto-cursor-target">
          <br />
        </p>
        <ac:structured-macro ac:macro-id="0ec9408a-553c-4bf4-a0c8-77e367d98cb3" 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="432a5ff9-2cb5-498b-b7e7-cb9e68506828" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">data:mystatus &gt; collection:first &gt; text:find Approved</ac:parameter>
              <ac:rich-text-body>
                <p>
                  <br />
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
            <ac:structured-macro ac:macro-id="ed7a3a3d-4965-48ad-b8fb-0c8362c7693a" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="0f17a501-4102-4216-ac9a-eb650d051704" ac:name="status" ac:schema-version="1">
                  <ac:parameter ac:name="color">green</ac:parameter>
                  <ac:parameter ac:name="title">Approved</ac:parameter>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p>
          <br />
        </p>
        <ac:structured-macro ac:macro-id="644b601d-2db4-42b2-a300-e92ebded50c5" 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="ae5e737f-5beb-4f20-ad84-a0c68fa45900" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">data:mystatus &gt; collection:first &gt; text:find Rejected</ac:parameter>
              <ac:rich-text-body>
                <p>
                  <br />
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
            <ac:structured-macro ac:macro-id="d8816740-527c-496b-952b-17a68094ff8b" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="a20735f0-1bdc-45a4-915a-8d0a496afce1" ac:name="status" ac:schema-version="1">
                  <ac:parameter ac:name="color">red</ac:parameter>
                  <ac:parameter ac:name="title">Rejected</ac:parameter>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p>
          <br />
        </p>
        <ac:structured-macro ac:macro-id="e333045e-b8ab-4876-9d5a-f87cbf388021" 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="c884ac52-d7f6-43a5-9d52-8700613dd25c" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">data:mystatus &gt; collection:first &gt; text:find In Progress</ac:parameter>
              <ac:rich-text-body>
                <p>
                  <br />
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
            <ac:structured-macro ac:macro-id="d9c78e2d-7f8e-4731-97d8-40d5e72d2eb4" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="2784c410-4ebc-4e1e-8226-7439d163bee0" ac:name="status" ac:schema-version="1">
                  <ac:parameter ac:name="color">yellow</ac:parameter>
                  <ac:parameter ac:name="title">In Progress</ac:parameter>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p>
          <br />
        </p>
        <ac:structured-macro ac:macro-id="87adef73-90c3-4333-b1ad-c50cea3a9c9d" 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="16856858-4ae9-47c6-90b0-01248afecbb0" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">data:mystatus &gt; collection:first &gt; text:find Unassigned</ac:parameter>
              <ac:rich-text-body>
                <p>
                  <br />
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
            <ac:structured-macro ac:macro-id="e8d06039-32dc-4b95-89df-53ebefedc119" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="30bf0f7e-87e4-48ec-94a0-5b5cef9ec121" ac:name="status" ac:schema-version="1">
                  <ac:parameter ac:name="color">grey</ac:parameter>
                  <ac:parameter ac:name="title">Unassigned</ac:parameter>
                </ac:structured-macro>
              </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>
  </ac:rich-text-body>
</ac:structured-macro>
<hr />
<h3>Method 2:</h3>
<ac:structured-macro ac:macro-id="485be0b3-49d9-44d0-9703-240f31c4aaa3" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="2ebbf8da-c12e-41eb-981b-37b16eec1b86" ac:name="local-reporter" ac:schema-version="1">
      <ac:parameter ac:name="source">@self</ac:parameter>
      <ac:parameter ac:name="">data:mytable</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br />
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="a26f3205-ed4f-4aa2-aa60-81f94fde9409" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Title</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="be76f63a-cb40-4956-aac6-e8abed13d7e0" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:mytitle</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="fb8e39c2-3620-4f70-9ee2-1a6bc07d417a" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Status</ac:parameter>
      <ac:rich-text-body>
        <p class="auto-cursor-target">
          <br />
        </p>
        <ac:structured-macro ac:macro-id="aa92bad9-edfa-4e4f-bdd0-d7db14c4b6f3" 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="176cffab-744c-45e9-bcc6-b211457f777b" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">@self</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="12cac7c6-8f28-4589-843b-f89a4bab1ed0" ac:name="text-filter" ac:schema-version="1">
                  <ac:parameter ac:name="include">.*Approved.*</ac:parameter>
                  <ac:parameter ac:name="">data:mystatus</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="527c7c66-faff-4863-ae9c-e2f03b3ed491" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="e15c4b5d-b1ce-46da-9279-549b54db9123" ac:name="status" ac:schema-version="1">
                  <ac:parameter ac:name="color">green</ac:parameter>
                  <ac:parameter ac:name="title">Approved</ac:parameter>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p>
          <br />
        </p>
        <ac:structured-macro ac:macro-id="421181a5-c259-4351-b8ec-22767f3cc2c5" 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="7982629e-02c0-474a-805c-01d47b02567c" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">@self</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="525efb4b-429e-4a17-b0a2-7f16c746a898" ac:name="text-filter" ac:schema-version="1">
                  <ac:parameter ac:name="include">.*Rejected.*</ac:parameter>
                  <ac:parameter ac:name="">data:mystatus</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="f0a27872-dd1a-4883-9452-87cdf875fbca" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="46980c33-6c89-4d84-b066-f83ab9f99d30" ac:name="status" ac:schema-version="1">
                  <ac:parameter ac:name="color">red</ac:parameter>
                  <ac:parameter ac:name="title">Rejected</ac:parameter>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p>
          <br />
        </p>
        <ac:structured-macro ac:macro-id="dc958f7e-3f83-4de9-8956-95ff6ddb8b59" 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="cb1f3108-5978-47ba-9b33-4e3d2be7fa8c" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">@self</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="aab1f263-d01e-4291-bf18-0cefc3be128e" ac:name="text-filter" ac:schema-version="1">
                  <ac:parameter ac:name="include">.*In Progress.*</ac:parameter>
                  <ac:parameter ac:name="">data:mystatus</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="50371917-726e-4436-8647-c079ed9eb21d" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="4dad56ad-7ea1-4ade-807b-9d58cf90df8b" ac:name="status" ac:schema-version="1">
                  <ac:parameter ac:name="color">yellow</ac:parameter>
                  <ac:parameter ac:name="title">In Progress</ac:parameter>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p>
          <br />
        </p>
        <ac:structured-macro ac:macro-id="7ef00e1f-ba24-4aac-9c00-f909d4856e4c" 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="635d4f1d-917d-406e-83ea-ddb2f6d53ec7" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">@self</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="82be5656-d3fe-4622-8bac-d206728a7faf" ac:name="text-filter" ac:schema-version="1">
                  <ac:parameter ac:name="include">.*Unassigned.*</ac:parameter>
                  <ac:parameter ac:name="">data:mystatus</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="eecc3656-e33e-4ff5-8539-e2a9b0ad9153" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="9e01eddc-5d65-40d9-bc8d-524f180a4eaf" ac:name="status" ac:schema-version="1">
                  <ac:parameter ac:name="color">grey</ac:parameter>
                  <ac:parameter ac:name="title">Unassigned</ac:parameter>
                </ac:structured-macro>
              </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>
  </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

  • No labels